1 Replies - 1017 Views - Last Post: 18 July 2014 - 11:21 AM Rate Topic: -----

#1 kepler  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 13
  • Joined: 05-July 14

SQLite and VB6

Posted 18 July 2014 - 11:10 AM

Hi,

With the help of the forum members, I was able to put SQLite to work. I've imported my csv file to SQlite, and save it.
But there are a couple of doubts I have:
1) I've opened in a text editor the result file; there is no separation between the fields. Is this normal?
2) Wich control (specific) do I have to use, to access the database in VB6?
3) Wich routine - code - do I use?

Can someone be so kind to help me?

Kind regards,

Kepler

Is This A Good Question/Topic? 0
  • +

Replies To: SQLite and VB6

#2 andrewsw  Icon User is online

  • Fire giant boob nipple gun!
  • member icon

Reputation: 3480
  • View blog
  • Posts: 11,875
  • Joined: 12-December 12

Re: SQLite and VB6

Posted 18 July 2014 - 11:21 AM

1) It depends how you copied it. Unless you explicitly export it as a csv it won't re-insert commas.

Why do you need to copy it back-out anyway? It is in the database now so it is time to check the data by building queries against it.

2) There is an adodc control, but check out the Tutorials link at the top of this page and this Database Guide. Unless there is something in the tutorials section you may find it difficult to obtain information specifically about the combination of SQLite and VB6, but the principles, and most of the code, are the same regardless of the database in use.

SQLite connectionstrings

You'll probably need to find and download a specific driver to use within VB6. [Why VB6? It is ancient and obsolete.]

3) see 2).

This post has been edited by andrewsw: 18 July 2014 - 11:23 AM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1