SELECT Statement

[nhjyjetsfan]

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]

Disregard

MS vb.net issue

Thanks

 

[Leland123]

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]

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.