Article View: borland.public.vdbase.data.sql
Article #351Re: sql building bombs
From: Ken Mayer [TeamB]
Date: Thu, 22 Oct 1998 00:00
Date: Thu, 22 Oct 1998 00:00
30 lines
1763 bytes
1763 bytes
Charlie Lutz <lutzc@mail.wes.army.mil> wrote: >I tried to use the sql designer (although I think I have read Ken said >that is a no-no) and it crashes every time. Trying to get 2 tables (1 >with 109 fields and the other with 192 fields) linked. I add both >tables to the builder screen. Click on the check box to select all >fields in table 1, then click on the check box in table 2 and a series >of error msgs pop up telling me I have an access violation at address >..... Read of address FFFFFFFF. I click through several of these boxes >(4 or so) and then Vdb 7.01 GPF's. No way out. Don't use it. Period. <G> Sheesh. How many times do I have to tell you this, Charlie? What exactly are you trying to do? Chances are the SQL builder is trying to load the field names for each field (Select field1,field2 ..) for each table and is freaking itself out. Don't bother with it -- it's not really stable and not complete, and the SQL it streams out is a bit weird at times ... If you tell us what you want to do, chances are you can do it directly with the OODML objects and can bypass the durn thing completely ... Ken --- Ken Mayer [TeamB] Golden Stag Productions http://www.mindspring.com/~hirschv/homepage.htm http://www.mindspring.com/~hirschv/dbase/dbase.htm
Technical Details
Message-ID:
<362e716c.2603384@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<362E3F94.A9ACE8F6@mail.wes.army.mil>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,471cf22375e75c13 X-Google-Attributes: gidff5a1,public From: supportInfo@borland.com (Ken Mayer [TeamB]) Subject: Re: sql building bombs Date: 1998/10/22 Message-ID: <362e716c.2603384@forums.borland.com> X-Deja-AN: 403742296 References: <362E3F94.A9ACE8F6@mail.wes.army.mil> Organization: Golden Stag Productions Reply-To: teamb@opto-pps.com Newsgroups: borland.public.vdbase.data.sql