Re: please help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"Diego Cernuda" <diego@xxxxxx> skrev i en meddelelse
news:ea72MQ8TFHA.2420@xxxxxxxxxxxxxxxxxxxxxxx
> I'm from Spain and I'm started in the embedded visual basic. I need do an
> aplication for a PDA(whit a data base) and i don't known do "select * from
> table" to the data base.

If you need to do an application today, then you should be aware that new
PDA's are just around the corner, which will NOT support eVB programs.
You would therefore be well adviced to look into programming using either
eVC or a CE.NET based language like VB.NET or C#.net

> I find this code in a web, but i don´t understand.
> Set conndb = CreateObject("ADOCE.Connection.3.1")

This is a simple "Create an object of the type ADOCE.Connection". This
object is what will handle your connection to an underlying database using
ADOCE.
If you are going to look into other languages, then eVC doesn't readily
support ADOCE, and the .NET languages use ADOCE.NET, which is another beast.

> conndb.ConnectionString = "data source = \My Documents\mensaje.mdb"

This seems to come form the PC world. An .mdb file is an Access database.
The file on the device will have a name like "\My Documents\mensaje.cdb"

> conndb.Open

This should be fairly obvious: Open the connection to the database.

> Call LoadCtrl(Form1.GridCtrl1, "select mensajes from mensaje") --> what's
> this?

LoadCtrl must be an user-defined function elsewhere in the program you have
found.
My guess is that it will fill the grid named GridCtrl1 with data from a
table called mensaje in the database mensaje.cdb. From this table it selects
the field mensajes from all available records.

> conndb.Close

Close the database connection when you are done with it.

> Set conndb = Nothing

This is in fact not a very good idea. eVB has a memory leak in the
CreateObject function, so you will be better off re-using your connection
instead of freeing the object and then re-creating it the next time around.

> . please help me

I tried. But please take note of my warning against spending too much time
learning eVB.

/Keld Laursen


.

Relevant Pages

  • Re: SharePoint/SQL question
    ... alerts) in connection with those remaining sites won't work. ... the server that are connected to their own separate SQL database. ... SharePoint Services but are still getting Windows SharePoint Services ... The data base that the error is referring to has been removed from SQL ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: SharePoint/SQL question
    ... server that are connected to their own separate SQL database. ... All of my SharePoint web data is stored in an SQL ... Check the database connection information and make ... The data base that the error is referring to has been removed from SQL ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • ANN: Sequel 3.11.0 Released
    ... Sequel is a lightweight database access toolkit for Ruby. ... Sequel provides thread safety, connection pooling and a concise DSL ... for constructing database queries and table schemas. ...
    (comp.lang.ruby)
  • ANN: Sequel 3.9.0 Released
    ... Sequel is a lightweight database access toolkit for Ruby. ... Sequel provides thread safety, connection pooling and a concise DSL ... the default connection pool no longer contains ...
    (comp.lang.ruby)