Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CursorAdapter and Null values
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
01236827
Message ID:
01236853
Vues:
15
>Naomi,
>
>>Are you using insert or APPEND BLANK? AFAIK APPEND BLANK is not affected by SET NULL, only insert-SQL when not every field is specified.
>>
>>Ok, I didn't read your original statement carefully. Yes, you're using APPEND BLANK, so you're right, it's not affected.
>
>Yes, I'm using APPEND BLANK. After read your post, I tried to find a way to replace APPEND BLANK to INSERT-SQL, but VFP doens't accept just "INSERT INTO MyCursor". It needs to add, at least, one field... :-( - and I don't want to track it (in this case).
>
>Thanks again!

You can try with

insert into myCursor (MyCharField) values ("")

but it's not worth it and it will disallow to make the class generic. So, just stick with the schema unless someone knows a better way.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform