Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GenDBC generates a line MakeRI()
Message
From
05/10/2001 16:38:39
Gerald McKinsey
Keystone Consulting Services, Inc.
Yorktown, Indiana, United States
 
 
To
05/10/2001 09:08:22
Tobey Miller
Meridian Information Systems
Ft. Payne, Alabama, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00564712
Message ID:
00565004
Views:
19
Hey Tobey,

I had the exact same problem and discovered it was a problem with the GENDBC program itself. It had problems if you had two tables in youe DBC that shared a similar name. In our case the table names were Newsletter and NewsletterType. The problem was in the following line of code in the GETRI function of GENDBC:

WriteFile(m.hGTFile, "LOCATE FOR ObjectType = 'Table' AND ObjectName = '" + ;

It should be changed to:

WriteFile(m.hGTFile, "LOCATE FOR ObjectType = 'Table' AND ALLTRIM(ObjectName) == '" + ;

The problem was with the "=" operator. The line of code above IMHO needs to search for an EXACT match. By trimming the object name (the table) and using the "==" operator (which looks for an exact match), we were able to eliminate the problem.

HTH,

Brian
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform