Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Embadded SQL

2 posts in Appeon (partner product) Last posting was on 2004-04-29 11:53:06.0Z
Stelios Posted on 2004-04-29 06:18:08.0Z
Reply-To: "Stelios" <stebas@mdm.gr>
From: "Stelios" <stebas@mdm.gr>
Newsgroups: sybase.public.appeon
Subject: Embadded SQL
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 212.205.169.248
X-Original-NNTP-Posting-Host: 212.205.169.248
Message-ID: <40909e20@forums-1-dub>
Date: 28 Apr 2004 23:18:08 -0700
X-Trace: forums-1-dub 1083219488 212.205.169.248 (28 Apr 2004 23:18:08 -0700)
X-Original-Trace: 28 Apr 2004 23:18:08 -0700, 212.205.169.248
X-Authenticated-User: appeon
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:223
Article PK: 12438

Hi,

I want to use embadded sql, but it doesnt work. I want to ask if i must
make a connection first before use embadded sql because i show that appeon
doesnt see the tables in the database although i use SQLCA! This happens
only in embadded sql, in datawindows and stored procedures works fine.

Thanks

Stelios


Stelios Posted on 2004-04-29 11:53:06.0Z
Reply-To: "Stelios" <stebas@mdm.gr>
From: "Stelios" <stebas@mdm.gr>
Newsgroups: sybase.public.appeon
References: <40909e20@forums-1-dub>
Subject: Re: Embadded SQL
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 212.205.169.228
X-Original-NNTP-Posting-Host: 212.205.169.228
Message-ID: <4090eca2@forums-1-dub>
Date: 29 Apr 2004 04:53:06 -0700
X-Trace: forums-1-dub 1083239586 212.205.169.228 (29 Apr 2004 04:53:06 -0700)
X-Original-Trace: 29 Apr 2004 04:53:06 -0700, 212.205.169.228
X-Authenticated-User: appeon
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:224
Article PK: 20639

I found the problem myself. My database was setup case sesnsitive and i
discovered that appeon converts all the sql code to small letters and my
tables and columns are in capital letters. Anyway i wrote all the sql in
stored procedure and solve the problem.

Stelios




Ï "Stelios" <stebas@mdm.gr> Ýãñáøå óôï ìÞíõìá news:40909e20@forums-1-dub...

>
>
> Hi,
>
> I want to use embadded sql, but it doesnt work. I want to ask if i must
> make a connection first before use embadded sql because i show that appeon
> doesnt see the tables in the database although i use SQLCA! This happens
> only in embadded sql, in datawindows and stored procedures works fine.
>
> Thanks
>
> Stelios
>
>