• Registered: 2020-03-31
  • Posts: 233

Topic: Error

Can any one tell about this kind of attached pic? How it come up and what is its sulution?

Post's attachments

Attachment icon Capturex.PNG 3.26 kb, 65 downloads since 2022-03-15 

  • Registered: 2014-08-02
  • Posts: 914

Re: Error

Hello unforgettable

How difficult to answer you.
Let us know under what conditions this appears:
SQL query, calculation between several values, variable definition error...
There can be several explanations.
Give us an example of your project and tell us after which operation this occurs.
JB

  • Registered: 2020-03-31
  • Posts: 233

Re: Error

It appear while calculation between several values.

When values from corresponding field is empty.

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,684

Re: Error

To re-iterate what JB has written, without seeing your project, you are very unlikely to get any sort of help.
Derek.

  • Registered: 2020-03-31
  • Posts: 233

Re: Error

Hi derek,
           I got this kinf of  error " could not convert variant of type(unicodestring) into type(double) by typing following script.
Reception.Edit1.Value:= SQLExecute('Select Sum((Advance)+(Received)) from Fees Where Date(sdate1) = "' + FormatDateTime('YYYY-MM-DD',Reception.dtp.DateTime) + '"');

Reception.Edit2.Value:= SQLExecute('Select Sum((paid)+(lpaid)) from Expenses Where Date(date1) = "' + FormatDateTime('YYYY-MM-DD',Reception.dtp.DateTime) + '"');

Reception.Edit3.Value:= SQLExecute('Select Sum((Advance)+(Received)) from Fees Where Date(sdate1) = "' + FormatDateTime('YYYY-MM-DD',Reception.dtp.DateTime) + '"')-SQLExecute('Select Sum((paid)+(lpaid)) from Expenses Where Date(date1) = "' + FormatDateTime('YYYY-MM-DD',Reception.dtp.DateTime) + '"');

any solution?

  • From: Gotham City
  • Registered: 2017-12-31
  • Posts: 406

Re: Error

I think you have to change edit.value to edit.text or vartostr(sqlquery)
Try both options

  • Registered: 2020-03-31
  • Posts: 233

Re: Error

I tried edit.value to edit.text but still I got that error message. Can you tell about other option vartostr(sqlguery)?

8 Reply by sparrow (edited by sparrow 2022-03-23 11:32:24)

  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 898

Re: Error

bllackpearl is right.
Replace
Reception.Edit1.Value on Reception.Edit1.Text
Reception.Edit2.Value on Reception.Edit2.Text


and modify last
Reception.Edit3.Value:= Reception.Edit1.Value - Reception.Edit2.Value;


OR


Reception.Edit1.Value:= SQLExecute('Select IFNULL(Sum((Advance)+(Received)),0) from Fees ...
Reception.Edit2.Value:= SQLExecute('Select IFNULL(Sum((paid)+(lpaid)),0) from Expenses ...
and modify last
Reception.Edit3.Value:= Reception.Edit1.Value - Reception.Edit2.Value;


In addition, SQLExecute is a very simple function and can only output one result.
If the result contains several values, only the first one will be returned, which will be an error.

  • Registered: 2020-03-31
  • Posts: 233

Re: Error

Thank you every one.
It works correctly. Can you explain this error in some detail, sparrow?

  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 898

Re: Error

The returned result can be NULL, which results in an error.
Solutions two
1 Use (edit1.text ...)
2 Exclude possibility of NULL result in SQL query IFNULL ( ,0)

  • Registered: 2020-03-31
  • Posts: 233

Re: Error

Hi sparrow,
             Thank you sparrow to guide.