Article View: comp.lang.basic.visual.3rdparty
Article #23Re: creating new Access db with SQL (VB6)
From: Jasmyn
Date: Fri, 02 Apr 1999 00:00
Date: Fri, 02 Apr 1999 00:00
29 lines
2006 bytes
2006 bytes
Try using visdata to create your database, and make the field types variable length that should do the trick (i think) Please tell me if I'm wrong. Jasmyn -x- Rotem Zucker <es@netvision.net.il> wrote in message news:7drock$868$1@news.netvision.net.il... >Urgent! > >i have no problems creating the database, but... >when i use the INSERT INTO thing, the problem is that the field is being >filled up to it's width with spaces.... > >for example: if the field width is 5 and i put the value X inside... the >result will be: 'X____' > >how can i avoid these spaces? > >i tried to re-update the fields and trim the spaces, but it does that >everytime.... even if i manually change the database from within Access. > >please help: es@netvision.net.il > >Thank you very much! > >
Technical Details
Message-ID:
<7e36pa$ppo$1@newnews.global.net.uk>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<7drock$868$1@news.netvision.net.il>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 110e3b,3aeaa90d061e167d X-Google-Attributes: gid110e3b,public X-Google-Thread: 10b997,3aeaa90d061e167d X-Google-Attributes: gid10b997,public X-Google-Thread: 108062,3aeaa90d061e167d X-Google-Attributes: gid108062,public X-Google-Thread: f5f6f,3aeaa90d061e167d X-Google-Attributes: gidf5f6f,public X-Google-Thread: 111c14,3aeaa90d061e167d X-Google-Attributes: gid111c14,public X-Google-Thread: 1143a7,3aeaa90d061e167d X-Google-Attributes: gid1143a7,public X-Google-Thread: 107824,3aeaa90d061e167d X-Google-Attributes: gid107824,public From: "Jasmyn" <jasmyn@galaxycorp.com> Subject: Re: creating new Access db with SQL (VB6) Date: 1999/04/02 Message-ID: <7e36pa$ppo$1@newnews.global.net.uk> X-Deja-AN: 462046709 References: <7drock$868$1@news.netvision.net.il> X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0810.800 X-MSMail-Priority: Normal Reply-To: "Jasmyn" <jasmyn@galaxycorp.com> Newsgroups: comp.lang.basic.visual.3rdparty,comp.lang.basic.visual.database,comp.lang.basic.visual.misc,cz.comp.lang.basic.visual,fj.comp.lang.visualbasic,it.comp.lang.visual-basic,no.it.programmering.visual-basic