Source language: Translate to:

sql samples

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

sql samples

Postby yanzco » Mon Feb 23, 2015 8:50 pm

hello guys..
when i use dbpro.. i use it only with microsoft access...
ive been curious with sql database..
ive never used it..

any samples out there?
basic introduction to tables to changing records together with dbpro..
yanzco
 
Posts: 178
Joined: Sun Jul 20, 2014 4:07 am

Re: sql samples

Postby stu » Tue Feb 24, 2015 7:22 am

I've found out that the best way of doing things while working with MSSQL is to use dbpExecSQL instead of some of the preset functions, some of them, like the navigation work fine but other like dbpDefineRelationship tend to be a bit ineffective. For building relationships its always better to use MSSMS, actually for building the DB, then you just call it from nb.
User avatar
stu
 
Posts: 320
Joined: Wed Aug 07, 2013 11:37 am

Re: sql samples

Postby Neosoft Support » Tue Feb 24, 2015 10:53 am

Access databases work really well with DBPro because the required files are included as part of Windows. For all other types of databases, you must download and install software, drivers, etc. (like mySQL). Because of this and the way some of these other database engines store their content it's very difficult to create samples apps that will work everywhere.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5605
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Re: sql samples

Postby dpayer » Tue Feb 24, 2015 3:17 pm

Remember, W3Schools.com is your friend:

http://www.w3schools.com/sql/default.asp

They teach generic SQL syntax. In some cases it is different than MS Access.

Each lesson has samples.
David Payer
Des Moines, Iowa
USA
User avatar
dpayer
 
Posts: 1384
Joined: Mon Apr 11, 2005 5:55 am
Location: Iowa - USA

Re: sql samples

Postby yanzco » Tue Feb 24, 2015 8:40 pm

no wonder access was too easy with dbpro.. i guess i have to try learn a bit or two of mysql first..
ill try if i have free time.. i was thinking of moving up with which database i should use, thought mysql was better than access.. :o
yanzco
 
Posts: 178
Joined: Sun Jul 20, 2014 4:07 am


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest