Re: Step 1 with Visual Basic

2008/6/17 Gary <sql(at)4myad(dot)tv>:

> Richard Broersma wrote:
>
> On Tue, Jun 17, 2008 at 1:00 PM, Gary <sql(at)4myad(dot)tv> <sql(at)4myad(dot)tv> wrote:
>
> 1. I'm clicking on Reply. Is this only going to you and if so should I be
> doing something different?
>
> Ya. Reply-All is for the benifit of the whole PostgreSQL Community.
> This way others listening in can benifit from the discussion and
> people more experienced or smarter that I can chime in to correct my
> mis-information :o) . Also the answer is posted to the PostgreSQL
> Archieves. This way the answers are stored for others to research
> later.
>
> 2. I know the username and password of the database, nothing else. When I
> first installed the application, I have a vague memory of doing something
> and getting "dos looking" window with a prompt. I believe I had to enter /q
> to exit. I don't remember what I did to get that far.
>
> these should fill in the missing details
> http://www.connectionstrings.com/?carrier=postgresql about connection strings
> http://msdn.microsoft.com/en-us/library/ms807027.aspx about connection.open
> http://support.sas.com/documentation/tools/oledb/rr_sqliomshare.htm
>
> 3. I understand about 50% of your example. I need to back up to the
> beginning. Where do I look for "SQL for Dummies?"
>
> Well, I think there are too many SQL dummies out there, so I would
> recommend this book instead ;) :
> http://www.elsevier.com/wps/find/bookdescription.cws_home/706077/description#description
>
> Sorry to be such a pest. If I could understand these documents I
> probably wouldn't have to read them. I've been zipping around the net
> reading docs but nowhere do they start at the beginning.
>
> I've rediscovered how to start the interactive terminal and even listed the
> commands. Might as well be in Chinese.
>
>
>
>
> I've searched and Googled but I don't know the jargon and can't get close
> to the right topic.
>
> Seems like step 1 might be to determine the names of the data fields in the
> database. (tables & ?). How do I do that?
>
> Is there a newsgroup with "training wheels"?
>

I found this to be a GREAT resource for learning SQL: The Practical SQL
Handbook ... here's a link to Amazon
http://www.amazon.com/Practical-SQL-Handbook-Using-Variants/dp/0201703092/ref=sr_1_1?ie=UTF8&s=books&qid=1213748053&sr=8-1

-Bret

Thanks,

--
- Bret