Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appending Records
Message
From
03/04/2002 05:11:41
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
03/04/2002 04:40:25
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00640256
Message ID:
00640258
Views:
13
>Hi everyone
>
>I'm having problems appending records to a table, the table in question is
>a child table and in order to append records to it, I first append a blank and then replace values into the fields. Using debugger I can see the values in the table but once I continue using the application the records disappear.
>
>I would be grateful for any pointers on what I might be doing wrong, thank u all in advance for your feedback
>
>
>
>Omran

Probably in a parent-child relation the values you provide for new record doesn't match with the relation key to parent's active record.
PS:I strongly recommend using 'insert into' instead of 'append blank..replace'
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform