Re: How to know columns names in Derby database table

On Sun, 23 Sep 2007 09:54:50 +0200, "Luis Angel Fdez. Fdez."
<laffdez@xxxxxxxxx> wrote, quoted or indirectly quoted someone who
said :

[...]

The connection is made, and the 'bornes' table exists, but the loop is
never executed. What's wrong?

another way to get this information is with commands like this:

SHOW DATABASES; -- examine list of supported databases
USE mydata; -- select mydata database
SHOW TABLES; -- examine tables in mydata database
DESCRIBE animals; -- look at column descriptions in the animals table
CREATE DATABASE plants; -- create a new database.
--
Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com
.

Relevant Pages

  • Re: RunCommand acCmdRecordsGoToNext
    ... Another thing that may come in handy if that doesn't is to loop through the ... The database I am utilizing this ... increasing intRecordCount on each loop. ... Dim strPassword As String ...
    (microsoft.public.access.forms)
  • Re: Sql Connection
    ... ..i dont like the code either....again a example of a loop ... making calls to the database .... ... what i did yesterday is just get the parsed data to a temp table on the ... the question is the open connection where the Datareader is used insid ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: What to do with 3 Acres of land?
    ... "The rules applicable to the identification and movement of cattle and sheep ... Penalties for error. ... all animals ears are read etc). ... The database will have errors. ...
    (uk.business.agriculture)
  • Re: Converting from Access to SQL2k via Excel- HELP!!!!!
    ... Then create a new query and paste the following into its SQL ... > In your database you'd need to start with a query that ... The function that you pointed me to allows me to concatenate all ... The problem that I have is that I need to put it into a loop ...
    (microsoft.public.access.conversion)
  • Re: View contents of a folder
    ... For example, if your backup files are located on your D drive, in the backup ... to loop through that directory looking for other files that match the ... allows you to copy the backup file over your backend database, ... >> Folder browser and let you select a file via that mechanism. ...
    (microsoft.public.access.queries)