Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement