Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Two table in one
Message
 
To
22/04/2007 01:17:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01218574
Message ID:
01218657
Views:
17
>Thanks a lot, I'll look through it.

I just saw a bug in my code :-) (maybe there are others)
SCAN
   IF Id # m.lnId
      lnNextField = 1
      lnId        = crsTest.Id
      *** APPEND BLANK IN crsChid 
      INSERT INTO crsChid (Id) VALUES (crsTest.Id)
   ENDIF
   lcFldName = [pcField]+TRANSFORM(lnNextField)
   REPLACE &lcFldName WITH crsTest.cField1 IN crsChid
   lnNextField = lnNextField + 1
ENDSCAN
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform