help please - MF netexpress 3.1, ODBC, dbase,Win2K 
Author Message
 help please - MF netexpress 3.1, ODBC, dbase,Win2K

I'm trying to use NetExpress 3.1 to read data from DBase III file using
ODBC.  Operating environment is Windows 2000.

The CONNECT seems to work, but I can't seem to get SELECT to work.

Can you help aim me in the right direction?

Charlie Goodman



Fri, 11 Jun 2004 17:31:59 GMT  
 help please - MF netexpress 3.1, ODBC, dbase,Win2K
We need more details.

Have you set up the ODBC data source using ODBC32, and pointed it at the
DBase file?

Please post the embedded SQL with the SELECT in it.

Pete.


Quote:
> I'm trying to use NetExpress 3.1 to read data from DBase III file using
> ODBC.  Operating environment is Windows 2000.

> The CONNECT seems to work, but I can't seem to get SELECT to work.

> Can you help aim me in the right direction?

> Charlie Goodman

 Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
    ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------        
                http://www.usenet.com


Fri, 11 Jun 2004 19:35:05 GMT  
 help please - MF netexpress 3.1, ODBC, dbase,Win2K

Quote:

> Please post the embedded SQL with the SELECT in it.

> Pete.

> Please post the embedded SQL with the SELECT in it.

> Pete.

Peter,

Thanks for your reply to my usenet request.

I am experimenting with a bastardized version of the MF demo program
"base\emo\odbcesql\SELECT.CBL".

           EXEC SQL CONNECT TO "imi" END-EXEC.
seems to work as the field sqlcode is zero

I added a few data items
           EXEC SQL BEGIN DECLARE SECTION END-EXEC.
       01  pcustid             pic x(5).
       01  pcompany            pic x(40).
       01  pcity               pic x(20).
       01  pstate              pic x(20).
       01  ws-ident    pic x(40).
       01  ws-original pic x(40).
       01  ws-title    pic x(40).
       01  ws-find     pic x(40).
       EXEC SQL END DECLARE SECTION END-EXEC.

now my attempt at a select
           move "MUXX105" to ws-find
           EXEC SQL
             SELECT ident, original, title
               INTO :ws-ident, :ws-original, :ws-title
               WHERE ident = :ws-find
           END-EXEC

The DBase III structure:
   Structure for database: C:IMI.dbf
   Number of data records:  211691
   Date of last update   : 10/01/01
   Field  Field Name  Type       Width    Dec
       1  IDENT       Character      7
       2  ORIGINAL    Character     14
       3  ORDERTYPE   Character     20
       4  CLIENT      Numeric        5
       5  ITEM        Numeric        5
       6  DID         Numeric       10
       7  TITLE       Character      5
       8  FIRST       Character     15
       9  INITIALS    Character      5
      10  LAST        Character     30

After the SELECT sqlcode has a value of -0000003010

Best Regards for the season,

Charlie Goodman
Winnipeg Canada



Sat, 12 Jun 2004 00:47:55 GMT  
 help please - MF netexpress 3.1, ODBC, dbase,Win2K
Charlie,

No doubt Pete will give you a satisfactory reply. If you are a bit
'vague' about the syntax, take a look at the OpenESQL  Assistant. Looks
a bit daunting at first, but fairly straight forward when you study it.
Most importantly it does your syntax for you depending upon your
selection criteria.

Joyeux Noel to you in Winterpeg <G>

Jimmy, Calgary AB

Quote:

> > Please post the embedded SQL with the SELECT in it.

> > Pete.

> > Please post the embedded SQL with the SELECT in it.

> > Pete.

> Peter,

> Thanks for your reply to my usenet request.

> I am experimenting with a bastardized version of the MF demo program
> "base\emo\odbcesql\SELECT.CBL".

>            EXEC SQL CONNECT TO "imi" END-EXEC.
> seems to work as the field sqlcode is zero

> I added a few data items
>            EXEC SQL BEGIN DECLARE SECTION END-EXEC.
>        01  pcustid             pic x(5).
>        01  pcompany            pic x(40).
>        01  pcity               pic x(20).
>        01  pstate              pic x(20).
>        01  ws-ident    pic x(40).
>        01  ws-original pic x(40).
>        01  ws-title    pic x(40).
>        01  ws-find     pic x(40).
>        EXEC SQL END DECLARE SECTION END-EXEC.

> now my attempt at a select
>            move "MUXX105" to ws-find
>            EXEC SQL
>              SELECT ident, original, title
>                INTO :ws-ident, :ws-original, :ws-title
>                WHERE ident = :ws-find
>            END-EXEC

> The DBase III structure:
>    Structure for database: C:IMI.dbf
>    Number of data records:  211691
>    Date of last update   : 10/01/01
>    Field  Field Name  Type       Width    Dec
>        1  IDENT       Character      7
>        2  ORIGINAL    Character     14
>        3  ORDERTYPE   Character     20
>        4  CLIENT      Numeric        5
>        5  ITEM        Numeric        5
>        6  DID         Numeric       10
>        7  TITLE       Character      5
>        8  FIRST       Character     15
>        9  INITIALS    Character      5
>       10  LAST        Character     30

> After the SELECT sqlcode has a value of -0000003010

> Best Regards for the season,

> Charlie Goodman
> Winnipeg Canada



Sat, 12 Jun 2004 01:44:50 GMT  
 help please - MF netexpress 3.1, ODBC, dbase,Win2K
On Mon, 24 Dec 2001 16:47:55 UTC, "Charlie Goodman"

Quote:

> > Please post the embedded SQL with the SELECT in it.

> > Pete.

> > Please post the embedded SQL with the SELECT in it.

> > Pete.

> Peter,

> Thanks for your reply to my usenet request.

> I am experimenting with a bastardized version of the MF demo program
> "base\emo\odbcesql\SELECT.CBL".

>            EXEC SQL CONNECT TO "imi" END-EXEC.
> seems to work as the field sqlcode is zero

> I added a few data items
>            EXEC SQL BEGIN DECLARE SECTION END-EXEC.
>        01  pcustid             pic x(5).
>        01  pcompany            pic x(40).
>        01  pcity               pic x(20).
>        01  pstate              pic x(20).
>        01  ws-ident    pic x(40).
>        01  ws-original pic x(40).
>        01  ws-title    pic x(40).
>        01  ws-find     pic x(40).
>        EXEC SQL END DECLARE SECTION END-EXEC.

> now my attempt at a select
>            move "MUXX105" to ws-find
>            EXEC SQL
>              SELECT ident, original, title
>                INTO :ws-ident, :ws-original, :ws-title
>                WHERE ident = :ws-find
>            END-EXEC

> The DBase III structure:
>    Structure for database: C:IMI.dbf
>    Number of data records:  211691
>    Date of last update   : 10/01/01
>    Field  Field Name  Type       Width    Dec
>        1  IDENT       Character      7
>        2  ORIGINAL    Character     14
>        3  ORDERTYPE   Character     20
>        4  CLIENT      Numeric        5
>        5  ITEM        Numeric        5
>        6  DID         Numeric       10
>        7  TITLE       Character      5
>        8  FIRST       Character     15
>        9  INITIALS    Character      5
>       10  LAST        Character     30

> After the SELECT sqlcode has a value of -0000003010

> Best Regards for the season,

> Charlie Goodman
> Winnipeg Canada

Hi Charlie, long time no see

The SELECT INTO can only select a single row from the table. Are you
sure that there is only one that matches the select criteria?

Lorne Sunley (from the old Compushare/{*filter*}share days)

Contact me via e-mail if you need help with this, I've done a bunch of
Netexpress ESQL stuff lately.

--
Lorne Sunley



Sat, 12 Jun 2004 02:58:46 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. MF Cobol + Web (Netexpress 3.1)

2. NetExpress 3.1 Socket call and Connect to ODBC database

3. VSE 3.1 Repository Problem: Please help (please please?)

4. TopSpeed - ODBC 3.1???? HELP HELP HELP

5. Mf Cobol /net Express 3.1 Gurus... Help Needed

6. Fujitsu 4.0 vs MF NetExpress & MF Resolve

7. Fujitsu 4.0 vs MF NetExpress & MF Resolve

8. Dynamic SQL with NetExpress 3.1

9. Netexpress 3.1/Dialog System:Validate

10. Netexpress 3.1/Dialog System:Selection Box

11. NetExpress (3.1) and PC_PRINT routines

12. Printing with Merant Netexpress 3.1 over WINDOWS 9X/NT

 

 
Powered by phpBB® Forum Software