Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alter default 'Add' button behavior
Message
From
14/06/1999 16:02:35
 
 
To
14/06/1999 16:01:07
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00229627
Message ID:
00229684
Views:
26
OK :-)

>Like I said, it's monday...
>
>OK, now I understand how you use INSERT INTO. I guess that you defined your rules in the view, that's why you can't use APPEND BLANK. I've allways defined my rules on the table, not on the view. That's why I could use APPEND BLANK on the view.
>
>>>So you do a INSERT INTO with blank values for all fields. What are the advantages of using INSERT INTO vs APPEND BLANK in that situation?
>>
>>No I don't. But I do insert with fields that require a value as defined in my database constraints.
>>
>>>Using INSERT INTO means that you have to include one value for each field of the table in the right order
>>
>>No, no. You can use INSERT INTO with whatever fields you want in whatever order. For example, if I have defined a rule for a field in the DBC() such as !EMPTY(field) then I *have* to use INSERT INTO (field) VALUES (value) because APPEND BLANK will generate an error.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform