creating new Access db with SQL (VB6)

Thread View: comp.lang.basic.visual.3rdparty

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Rotem Zucker Wed, 31 Mar 1999 00:00

#28

Author: Rotem Zucker
Date: Wed, 31 Mar 1999 00:00

17 lines
1870 bytes

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!

Re: creating new Access db with SQL (VB6)

#23

Author: Jasmyn
Date: Fri, 02 Apr 1999 00:00

29 lines
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!
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads