Hello All,
I have peculiar problem which appears to be trivial, but i just can't seem
to solve it.
PB/PFC 6.5, and Sybase SQL Anywhere 5.5 database.
I have a simple datawindow with a date column (which is part of the primary
key).
When i save the data - dw_1.update(). - i get this message
Message: SQLSTATE = 07006
[Sybase][ODBC Driver]: cannot convert 0 to a date
No changes made to database.
INSERT INTO "My_Table( "col_1", "col_2", "date_column", "value_column" )
VALUES ( ?, ?, ?, ? )
I have a simple commandbutton which issues the update .
Although the module is pfc based, i created a simple window - NOT inherited
from w_sheet, with a datawindow - NOT inherited from u_dw, and 2
commandbuttons to test this case.
My save button script is:
dw_1.accepttext()
ll_row = dw_1.getrow()
if (ll_row > 0) then
... get the data into local variables.
... check is null, and notify user - return
ll_rtn = dw_1.update()
... check rtn code and Commit
end if
Any suggestions are welcome.
PB/PFC 6.5, and Sybase SQL Anywhere 5.5 database.
Thanks
Anand
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
