Stored proc problem MS SQL 2000

Gogolev Andrey

Delphi Developer

Fri, 19 Aug 2005 22:09:37 GMT

Stored proc problem MS SQL 2000

Stored procedure doesn't return any data. It was found out that if there is
a 'create #t (...)' statement and 'select * ...' statement after it in any
procedure then it will not return any data but if I'll disable creation of
temporary table then all is ok and procedure returns data.

I use fixed dbexpress driver(Delphi 7) and SQLDataSet component.

Thank you in advance for your comments,
Gogolev Andrey

Faru

Delphi Developer

Sat, 20 Aug 2005 23:46:51 GMT

Re:Stored proc problem MS SQL 2000

Hi;
I have the same problem too. I have a simple storedproc with one input(int)
and one output(int) params. I works both from Query Analyzer and Delphi, but
I can't get result from delphi (allways null).
Best Regards...
Faruk KAYNAKLI

Quote

> Stored procedure doesn't return any data. It was found out that if there
is
> a 'create #t (...)' statement and 'select * ...' statement after it in any
> procedure then it will not return any data but if I'll disable creation of
> temporary table then all is ok and procedure returns data.

> I use fixed dbexpress driver(Delphi 7) and SQLDataSet component.

> Thank you in advance for your comments,
> Gogolev Andrey

Petar Damjanovsk

Delphi Developer

Sun, 21 Aug 2005 15:20:37 GMT

Re:Stored proc problem MS SQL 2000

Hi;
I have the same problem too.
My storedproc just have one statement
"insert into Tablename ('Name', 100)"
and one output(TDateTime) parameter.
If I disable insert statement storedproc return output parameter correctly.

Help

Quote

"Faruk" <adi_soy...@hotmail.com> wrote in message

news:3e64ca6f@newsgroups.borland.com...

Quote

> Hi;
> I have the same problem too. I have a simple storedproc with one
input(int)
> and one output(int) params. I works both from Query Analyzer and Delphi,
but
> I can't get result from delphi (allways null).
> Best Regards...
> Faruk KAYNAKLI

> > Stored procedure doesn't return any data. It was found out that if there
> is
> > a 'create #t (...)' statement and 'select * ...' statement after it in
any
> > procedure then it will not return any data but if I'll disable creation
of
> > temporary table then all is ok and procedure returns data.

> > I use fixed dbexpress driver(Delphi 7) and SQLDataSet component.

> > Thank you in advance for your comments,
> > Gogolev Andrey

Micha3 Chmielarczy

Delphi Developer

Sun, 21 Aug 2005 22:05:01 GMT

Re:Stored proc problem MS SQL 2000

Hi,

I had this same problem too.
I wrote post two months ago and since then as I see nothing changed.
I try another dbExpress driver from CoreLab http://www.corelab.com/ (works
!).
I'm waiting for new updated ver of Borland's driver.

Micha3 Chmielarczyk

U?ytkownik "Petar Damjanovski" <pe...@freemail.com.mk> napisa3 w wiadomo?ci
news:3e65a548@newsgroups.borland.com...

Quote

> Hi;
> I have the same problem too.
> My storedproc just have one statement
> "insert into Tablename ('Name', 100)"
> and one output(TDateTime) parameter.
> If I disable insert statement storedproc return output parameter
correctly.

> Help

> "Faruk" <adi_soy...@hotmail.com> wrote in message
> news:3e64ca6f@newsgroups.borland.com...
> > Hi;
> > I have the same problem too. I have a simple storedproc with one
> input(int)
> > and one output(int) params. I works both from Query Analyzer and Delphi,
> but
> > I can't get result from delphi (allways null).
> > Best Regards...
> > Faruk KAYNAKLI

> > > Stored procedure doesn't return any data. It was found out that if
there
> > is
> > > a 'create #t (...)' statement and 'select * ...' statement after it in
> any
> > > procedure then it will not return any data but if I'll disable
creation
> of
> > > temporary table then all is ok and procedure returns data.

> > > I use fixed dbexpress driver(Delphi 7) and SQLDataSet component.

> > > Thank you in advance for your comments,
> > > Gogolev Andrey

Petar Damjanovsk

Delphi Developer

Sun, 21 Aug 2005 23:52:07 GMT

Re:Stored proc problem MS SQL 2000

Please send me that driver. I couldn't find it.

Thanks you very much

Quote

"Micha3 Chmielarczyk" <mchmielarc...@interia.pl> wrote in message

news:3e66030d@newsgroups.borland.com...

Quote

> Hi,

> I had this same problem too.
> I wrote post two months ago and since then as I see nothing changed.
> I try another dbExpress driver from CoreLab http://www.corelab.com/ (works
> !).
> I'm waiting for new updated ver of Borland's driver.

> Micha3 Chmielarczyk

> U?ytkownik "Petar Damjanovski" <pe...@freemail.com.mk> napisa3 w
wiadomo?ci
> news:3e65a548@newsgroups.borland.com...
> > Hi;
> > I have the same problem too.
> > My storedproc just have one statement
> > "insert into Tablename ('Name', 100)"
> > and one output(TDateTime) parameter.
> > If I disable insert statement storedproc return output parameter
> correctly.

> > Help

> > "Faruk" <adi_soy...@hotmail.com> wrote in message
> > news:3e64ca6f@newsgroups.borland.com...
> > > Hi;
> > > I have the same problem too. I have a simple storedproc with one
> > input(int)
> > > and one output(int) params. I works both from Query Analyzer and
Delphi,
> > but
> > > I can't get result from delphi (allways null).
> > > Best Regards...
> > > Faruk KAYNAKLI

> > > > Stored procedure doesn't return any data. It was found out that if
> there
> > > is
> > > > a 'create #t (...)' statement and 'select * ...' statement after it
in
> > any
> > > > procedure then it will not return any data but if I'll disable
> creation
> > of
> > > > temporary table then all is ok and procedure returns data.

> > > > I use fixed dbexpress driver(Delphi 7) and SQLDataSet component.

> > > > Thank you in advance for your comments,
> > > > Gogolev Andrey

Micha3 Chmielarczy

Delphi Developer

Mon, 22 Aug 2005 15:18:59 GMT

Re:Stored proc problem MS SQL 2000

Sorry, I make mistake.
CoreLab's address is http://crlab.com/.

Micha3 Chmielarczyk

U?ytkownik "Petar Damjanovski" <pe...@freemail.com.mk> napisa3 w wiadomo?ci
news:3e661d23@newsgroups.borland.com...

Quote

> Please send me that driver. I couldn't find it.

> Thanks you very much

> "Micha3 Chmielarczyk" <mchmielarc...@interia.pl> wrote in message
> news:3e66030d@newsgroups.borland.com...
> > Hi,

> > I had this same problem too.
> > I wrote post two months ago and since then as I see nothing changed.
> > I try another dbExpress driver from CoreLab http://www.corelab.com/
(works
> > !).
> > I'm waiting for new updated ver of Borland's driver.

> > Micha3 Chmielarczyk

> > U?ytkownik "Petar Damjanovski" <pe...@freemail.com.mk> napisa3 w
> wiadomo?ci
> > news:3e65a548@newsgroups.borland.com...
> > > Hi;
> > > I have the same problem too.
> > > My storedproc just have one statement
> > > "insert into Tablename ('Name', 100)"
> > > and one output(TDateTime) parameter.
> > > If I disable insert statement storedproc return output parameter
> > correctly.

> > > Help

> > > "Faruk" <adi_soy...@hotmail.com> wrote in message
> > > news:3e64ca6f@newsgroups.borland.com...
> > > > Hi;
> > > > I have the same problem too. I have a simple storedproc with one
> > > input(int)
> > > > and one output(int) params. I works both from Query Analyzer and
> Delphi,
> > > but
> > > > I can't get result from delphi (allways null).
> > > > Best Regards...
> > > > Faruk KAYNAKLI

> > > > > Stored procedure doesn't return any data. It was found out that if
> > there
> > > > is
> > > > > a 'create #t (...)' statement and 'select * ...' statement after
it
> in
> > > any
> > > > > procedure then it will not return any data but if I'll disable
> > creation
> > > of
> > > > > temporary table then all is ok and procedure returns data.

> > > > > I use fixed dbexpress driver(Delphi 7) and SQLDataSet component.

> > > > > Thank you in advance for your comments,
> > > > > Gogolev Andrey

Petar Damjanovsk

Delphi Developer

Mon, 22 Aug 2005 16:39:28 GMT

Re:Stored proc problem MS SQL 2000

Thanks,

but this driver is trial version. You can use tables max with 6 columns.
This is not solution for me.
It is not fear from Borland !!!

Quote

"Micha3 Chmielarczyk" <mchmielarc...@interia.pl> wrote in message

news:3e66f561$1@newsgroups.borland.com...

Quote

> Sorry, I make mistake.
> CoreLab's address is http://crlab.com/.

> Micha3 Chmielarczyk

> U?ytkownik "Petar Damjanovski" <pe...@freemail.com.mk> napisa3 w
wiadomo?ci
> news:3e661d23@newsgroups.borland.com...
> > Please send me that driver. I couldn't find it.

> > Thanks you very much

> > "Micha3 Chmielarczyk" <mchmielarc...@interia.pl> wrote in message
> > news:3e66030d@newsgroups.borland.com...
> > > Hi,

> > > I had this same problem too.
> > > I wrote post two months ago and since then as I see nothing changed.
> > > I try another dbExpress driver from CoreLab http://www.corelab.com/
> (works
> > > !).
> > > I'm waiting for new updated ver of Borland's driver.

> > > Micha3 Chmielarczyk

> > > U?ytkownik "Petar Damjanovski" <pe...@freemail.com.mk> napisa3 w
> > wiadomo?ci
> > > news:3e65a548@newsgroups.borland.com...
> > > > Hi;
> > > > I have the same problem too.
> > > > My storedproc just have one statement
> > > > "insert into Tablename ('Name', 100)"
> > > > and one output(TDateTime) parameter.
> > > > If I disable insert statement storedproc return output parameter
> > > correctly.

> > > > Help

> > > > "Faruk" <adi_soy...@hotmail.com> wrote in message
> > > > news:3e64ca6f@newsgroups.borland.com...
> > > > > Hi;
> > > > > I have the same problem too. I have a simple storedproc with one
> > > > input(int)
> > > > > and one output(int) params. I works both from Query Analyzer and
> > Delphi,
> > > > but
> > > > > I can't get result from delphi (allways null).
> > > > > Best Regards...
> > > > > Faruk KAYNAKLI

> > > > > > Stored procedure doesn't return any data. It was found out that
if
> > > there
> > > > > is
> > > > > > a 'create #t (...)' statement and 'select * ...' statement after
> it
> > in
> > > > any
> > > > > > procedure then it will not return any data but if I'll disable
> > > creation
> > > > of
> > > > > > temporary table then all is ok and procedure returns data.

> > > > > > I use fixed dbexpress driver(Delphi 7) and SQLDataSet component.

> > > > > > Thank you in advance for your comments,
> > > > > > Gogolev Andrey

Murat A

Delphi Developer

Tue, 23 Aug 2005 01:23:43 GMT

Re:Stored proc problem MS SQL 2000

Hi,
I have same problem,
I don't understand why borland solve this problem yet. it is a big bug, and
i think there is no way to solve this problem except borland relase update
pack for dbexpress.

Quote

"Petar Damjanovski" <pe...@freemail.com.mk> wrote in message

news:3e67093f@newsgroups.borland.com...

Quote

> Thanks,

> but this driver is trial version. You can use tables max with 6 columns.
> This is not solution for me.
> It is not fear from Borland !!!

> "Micha3 Chmielarczyk" <mchmielarc...@interia.pl> wrote in message
> news:3e66f561$1@newsgroups.borland.com...
> > Sorry, I make mistake.
> > CoreLab's address is http://crlab.com/.

> > Micha3 Chmielarczyk

> > U?ytkownik "Petar Damjanovski" <pe...@freemail.com.mk> napisa3 w
> wiadomo?ci
> > news:3e661d23@newsgroups.borland.com...
> > > Please send me that driver. I couldn't find it.

> > > Thanks you very much

> > > "Micha3 Chmielarczyk" <mchmielarc...@interia.pl> wrote in message
> > > news:3e66030d@newsgroups.borland.com...
> > > > Hi,

> > > > I had this same problem too.
> > > > I wrote post two months ago and since then as I see nothing changed.
> > > > I try another dbExpress driver from CoreLab http://www.corelab.com/
> > (works
> > > > !).
> > > > I'm waiting for new updated ver of Borland's driver.

> > > > Micha3 Chmielarczyk

> > > > U?ytkownik "Petar Damjanovski" <pe...@freemail.com.mk> napisa3 w
> > > wiadomo?ci
> > > > news:3e65a548@newsgroups.borland.com...
> > > > > Hi;
> > > > > I have the same problem too.
> > > > > My storedproc just have one statement
> > > > > "insert into Tablename ('Name', 100)"
> > > > > and one output(TDateTime) parameter.
> > > > > If I disable insert statement storedproc return output parameter
> > > > correctly.

> > > > > Help

> > > > > "Faruk" <adi_soy...@hotmail.com> wrote in message
> > > > > news:3e64ca6f@newsgroups.borland.com...
> > > > > > Hi;
> > > > > > I have the same problem too. I have a simple storedproc with one
> > > > > input(int)
> > > > > > and one output(int) params. I works both from Query Analyzer and
> > > Delphi,
> > > > > but
> > > > > > I can't get result from delphi (allways null).
> > > > > > Best Regards...
> > > > > > Faruk KAYNAKLI

> > > > > > > Stored procedure doesn't return any data. It was found out
that
> if
> > > > there
> > > > > > is
> > > > > > > a 'create #t (...)' statement and 'select * ...' statement
after
> > it
> > > in
> > > > > any
> > > > > > > procedure then it will not return any data but if I'll disable
> > > > creation
> > > > > of
> > > > > > > temporary table then all is ok and procedure returns data.

> > > > > > > I use fixed dbexpress driver(Delphi 7) and SQLDataSet
component.

> > > > > > > Thank you in advance for your comments,
> > > > > > > Gogolev Andrey

Other Threads

1. associate a sql 2000 server stored proc with a variable

2. MS SQL Server stored proc parameter problem

3. MS-SQL 6.5 & MS-SQL 2000

4. Help: Upgrading from MS SQL 6.5 to MS SQL 2000

5. Stored Proc w/ MS-SQL 7 = Acess Violation...?

6. MS SQL 6.5 Stored Proc with Text (Memo) Param

7. Unable to write MS-SQL Stored Proc via BDE/ODBC

8. MS-SQL Stored Proc not Executing

9. Anybody used to write MSSQL 2000 extended stored proc in Delphi

10. *** Using dataset returnet by a stored proc inside another stored proc ***