SELECT Statement

nhjyjetsfan · Apr 1, 2003

I am having a nightmare trying to retrieve data using a select statement. I can insert into my table but cannot retrieve via SELECT. I am stumped.

Using

SELECT * FROM tblemployees

returns nothing

If I use pgadmin i can retrieve my data with the exact SELECT statement above.

Discouraged...

nhjyjetsfan · Apr 1, 2003

Disregard

MS vb.net issue

Thanks

Leland123 · Apr 4, 2003

Hi nhjyjetsfan,

To execute you SQL from the command line enter ";" plus return like

SELECT * FROM tblemployees;

LelandJ Leland F. Jackson, CPA
Software - Master (TM)

https://www.smvfp.com

Nothing Runs Like the Fox

nhjyjetsfan · Apr 4, 2003

Thanks leland however that was not the issue...

the issue was specific to vb.net syntax...

By the way

I have a little tid bit for those who constantly ask:

What about stored procedures in postgre?

YES IT IS POSSIBLE>>>

I am going to post a simple stored procdure HOW TO this weekend (hopefully)

i have a MSSQL 2000 background and am migrating to Postgre to offer prospective customers an alternative to M$ awfully expensive solution for the small business owner.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

SELECT Statement

nhjyjetsfan

MIS

nhjyjetsfan

MIS

Leland123

Programmer

nhjyjetsfan

MIS

Similar threads

Part and Inventory Search

Sponsor