[nsbasic-ce] Ditto am looking for SQL Compact Edition samples with NSBASIC
annette.kord
Has anyone used the compact edition? I was using pocket access but it
is no more on windows mobile 5. What does everyone else use with
nsbasic? Samples please!
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___
annette.kord
George Henne
Here's a short sample from Tech Note 3a:
Dim objADO
Dim objRs
Dim strSQL
Dim strUserID
SqlOdbc="sql"
'Create ADO Object
Set objADO = CreateObject("ADODB.Connection")
' **** Open MS SQL DB by ADO ***
objADO.Open="SQL"
'Set SQL
strSQL="SELECT * from daily "
'Set DynaSet(RecordSet) Object
Set objRS = objADO.Execute(strSQL)
'Show records data
Do Until objRS.Eof = True
'Show the field
Print objRS(0),objRS(1),objRS(2),objRS(3)
'move next record
objRS.MoveNext
Loop
'Close ADO
objADO.Close
George Henne
NS BASIC Corporation
http://www.nsbasic.com
>Has anyone used the compact edition? I was using pocket access but it
>is no more on windows mobile 5. What does everyone else use with
>nsbasic? Samples please!
>
>
>
>
>Yahoo! Groups Links
>
>
>
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___
Annette Kord
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___
Annette Kord
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___
styskul
Try this: http://www.nsbasic.com/ce/info/technotes/TN15.htm SQLite is
compact, easy to use, and the same database works on both the PC and
PocketPC (and Linux, and I believe OS X).
--- In nsbasic-ce@yahoogroups.com, Annette Kord <annette.kord@...> wrote:
>
> Yea saw this in the technote, missing to much information for my pea
brain, need to know what needs to be installed on the handheld for
this to work I did install the SQL Server Compact Edition Core...
>
> When "SQL" is open in the sample below is "SQL" defined as an odbc
connection or a file, I tried it using my file specification and
received the activex cannot create object..using
CreateObject("Adodb.... Now I'm wondering how I get ADO onto the
handheld I don't think it came installed and I didn't put it there (at
least I don't think I did).
>
> I'm curious to know what other users are using I want something
simple with index capability like the old MDB/CDB files...don't want
to resort to a random or text file...and have to deal with sorting,
etc...what do other people use? Are all the apps written with NSBasic
non-db related? I saw all the samples are non-db related.
>
> Anyone out there writing a db app with ns-basic?
>
> ---------------------------------
> Never miss a thing. Make Yahoo your homepage.
>
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___
styskul
Try this: http://www.nsbasic.com/ce/info/technotes/TN15.htm SQLite is
compact, easy to use, and the same database works on both the PC and
PocketPC (and Linux, and I believe OS X).
--- In nsbasic-ce@yahoogroups.com, Annette Kord <annette.kord@...> wrote:
>
> Yea saw this in the technote, missing to much information for my pea
brain, need to know what needs to be installed on the handheld for
this to work I did install the SQL Server Compact Edition Core...
>
> When "SQL" is open in the sample below is "SQL" defined as an odbc
connection or a file, I tried it using my file specification and
received the activex cannot create object..using
CreateObject("Adodb.... Now I'm wondering how I get ADO onto the
handheld I don't think it came installed and I didn't put it there (at
least I don't think I did).
>
> I'm curious to know what other users are using I want something
simple with index capability like the old MDB/CDB files...don't want
to resort to a random or text file...and have to deal with sorting,
etc...what do other people use? Are all the apps written with NSBasic
non-db related? I saw all the samples are non-db related.
>
> Anyone out there writing a db app with ns-basic?
>
> ---------------------------------
> Never miss a thing. Make Yahoo your homepage.
>
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___
David A. Quinn
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
