SQL

SQL

Postby Jeff Barnes » Fri Apr 24, 2009 2:28 am

Hi,

I would like to start using an SQL database instead of the good old DBF database (this is my first try at sql so please forgive me if I have some terms incorrect)

Has the SQLWIN rdd been completed ?
Does this rdd let us use standard dbf commands or do we still need to know sql commands?

Are there any good free sql server apps out there?

Does anyone know of a good "beginners guide" or "SQL for dummies" type website?
Thanks,
Jeff Barnes

(FWH 16.11, xHarbour 1.2.3, Bcc730)
User avatar
Jeff Barnes
 
Posts: 929
Joined: Sun Oct 09, 2005 1:05 pm
Location: Ontario, Canada

Re: SQL

Postby nageswaragunupudi » Fri Apr 24, 2009 2:42 am

Mr Jeff

>
Does anyone know of a good "beginners guide" or "SQL for dummies" type website?
>

This is a free website and is very informative. You can learn all these from the scratch
http://www.w3schools.com/

Not only SQL, but many more that will be useful in relation to web
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10624
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: SQL

Postby Jeff Barnes » Fri Apr 24, 2009 2:45 am

Thank you. I will take a look at it. :D
Thanks,
Jeff Barnes

(FWH 16.11, xHarbour 1.2.3, Bcc730)
User avatar
Jeff Barnes
 
Posts: 929
Joined: Sun Oct 09, 2005 1:05 pm
Location: Ontario, Canada

Re: SQL

Postby Rick Lipkin » Fri Apr 24, 2009 1:17 pm

Jeff

Also look a www.connectionstrings.com .. ADO is the way to connect to SQL and it is the provider that changes .. not necessarily the syntax .. the connection string changes based on the SQL provider ..

Search the forum for ADO .. you will find lots of syntax and examples ..

Rick Lipkin
User avatar
Rick Lipkin
 
Posts: 2665
Joined: Fri Oct 07, 2005 1:50 pm
Location: Columbia, South Carolina USA


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 73 guests