Archived NeoSoft Support Forum

I stopped using Delphi after years of using it because it was too expensive for a casual programmer to keep updating. Neobook with Database and other add-ons does generally what I need at a very affordable cost. The only things I have not been able to do is create a particular type of custom reports...

Error message is Bookmark invalid The answer is usually 'create a primary index field such as AutoInc' when using Microsoft Access as the database. Should each Table in the Database have an primary index field? I am still getting this error (from time to time) usually after closing a Report. But not...

Tried for the fun of it but get Errors on Week, Day, Hour and Minutes.
But that's OK.

I know AutoInc Primary has been suggested before.
Most the tables have AutoInc Primary fields in this app.

Should all the tables have them?

To my surprise. I found out the three fields in must be represented in the GROUP BY clause in order to work.

I believe I found this on a Microsoft questions website.

Thanks for the responses. Gaev, I rounded the answer to 1 decimal place so if it rounded up that would happen. I used my own example. My birthday is in April therefore, I am not one year older until then. So I don't want it rounded up. If I was after April then it should round up. After looking into...

I wanted to write a small routine to determine the age of a person. DateToNum "[DateFld]" "Default" "[NumResult]" DateToNum "[DateShort]" "Default" "[Today]" Math "[Today]-[NumResult]" "0" "[Result]" Math "...

ReadOnly seems to refer to Grid. Would it apply to a Text Field too? Also, to make a change from Temp MemNo to Permanent MemNo, would I have to use dbpSetFieldProperties "Base" "Table" "Field" "ReadOnly=No" Then back to dbpSetFieldProperties "Base" &...

I have a membership database application with MemNo (member number) field string(12). The Only Text Entry Field is Disabled (not Enabled) which uses MemNo of database field. In theory the only way to changed the MemNo value is through a routine which I developed to Change from a Temporary member num...

Found another statement which works in another section in the code which works as expected by GROUP BY AccountNo. dbpExecSQL "NBAccounting" "INSERT INTO SumPreAccount (AccountNo,AcctSumDB,AcctSumCR,SumDiff) SELECT AccountNo,SUM(InAmt) AS AcctSumDB,SUM(OutAmt) AS AcctSumCR,(SUM(InAmt)-...

Tried to try your first statement dbpExecSQL "NBAccounting" "INSERT INTO IncomeExpenseTbl(AccountNo,AccountName,AccountType,TotalDebits,TotalCredits) SELECT AccountNo,AccountName,AccountType,SUM(InAmt) AS TotalDebits,SUM(OutAmt) AS TotalCredits FROM JrDetails;" "" Field...

The following Sql statement works. dbpExecSQL "NBAccounting" "INSERT INTO IncomeExpenseTbl (AccountNo,AccountName,AccountType,TotalDebits,TotalCredits) SELECT AccountNo,AccountName,AccountType,SUM(InAmt) AS TotalDebits,SUM(OutAmt) AS TotalCredits FROM JrDetails WHERE (JrDetailsDate BE...

Found Report Designer field causing the 'could not convert' message.
I deleted the field and re-did the field and message went away in preview in design mode.

But still haven't found the cause of 'Bookmark invalid' when I close the report.

When doing a Review in Report Designer, I get the message Could not convert variant of Type (String) into Type (Double) Not sure why I am getting this message. Several string fields, some currency, and totals. My suspect that Report designer is try to do a calculation with string or perhaps formatti...

Gaev,
was the key.
Thanks !