General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Yes, my mistake :), forget about it
YOU NEED date and datetime conversion for empty values if the backend doesn't support empty date/datetime. Or set null for those columns. I've converted empty dates to '1900-01-01' because I don't like null values for columns.
>Dorin,
>Thanks for the code but it's not me who needs it :)
>PS: Using ? you don't need type conversions for date/datetime and memo. See my first reply.
>Cetin
>
SNIP
>>>>I'm trying to insert a bunch of records using
>>>>
>>>>for n=1 to reccount()
>>>>scatter memvar
>>>>result=SQLEXEC(gnhandle,'insert into mytable (field1,field2,field3 etc) values (m.field1,m.field2,m.field3 etc),'')
>>>>endfor
>>>>
>>>>the "result" is coming back as minus 1 so obviously I've got something wrong.
>>>>
>>>>In any case, is there a more efficient way? Particularly for tables with large numbers of columns that looks horrendous!
>>>>
>>>>Thanks
>>>>
>>>>Harry
>>>
>>>Harry,
>>>Prefixing each column insert value with ? would do but a hard and long way :)
SNIP
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only