Mike Try CreateObject("adoce.recordset.3.0") - forget the connection for now. Try this test code Dim rsTest Set rsTest = CreateObject("adoce.recordset.3.0") ...
George, Version 5 is shipped with the program ceFileCopy.exe I can use this program to copy files to the device. Is it also possible to copy files from the...
One of my first projects consists of many small .nsb 'modules' (programs). Using the chain statement, the one program loads the next and back again etc, etc. I...
We created this utility to make it quicker to send programs from the IDE to the device. We don't have any need to do the reverse, so I don't expect we will be...
Hi George: I do not have the information available with me but I used the max. value listed and then divided this by 10. Created a pull down menu and added the...
How about this? ... If LoadedFromSource = False Then MsgBox "This program can only be run by Startup!", vbCritical + vbOKOnly, "Load Error" Bye ' could also...
using CreateObject("adoce.recordset.3.0") it still fails on the Open command: Const gDB = "\My Documents\MyDB.cdb" gRS.Open "CREATE TABLE MyTable (ColName...
What are the 2, 1 parameters in the open statement? I don't think you should need those for a create table command. -- Eric Pankoke Founder / Lead Developer ...
... you should need those for a create table command. That would be: Const adOpenDynamic = 2 Const adLockReadOnly = 1 I think I now have a better handle on...
Hey Bob, Thanks for your input. True. Definately better and shorter and works well! Great stuff! I'm alway looking to get the same job done with less code -...
With NSBASIC 5.02 (and W98), I can no more save the project with txt extension. The generated file has a null size. It was working fine with the previous...
Docs on this are missing in the Handbook, so here goes: WaveVolume is a global variable that can be set or displayed. WaveVolume=65535 'Maximum msgbox...
Thanks for your answer. I am using W98SE (French edition) It happens with all the programs I tried (around 5 differents including very simple one with only few...
How to you create primary indexes using ADOCE? I tried both: "CREATE table Clients (ClientID Text, PRIMARYKEY (ClientID), Description Text)" and "CREATE table...
General syntax: create index [indexname] on [table] ([fieldname {desc}]) Note that the parentheses are not there as a place holder or anything; they are...
First of all, my bad. I completely ignored the "primary" part of this whole thread. Second, try this: CREATE INDEX PRIMARYKEY ON Clients (ClientID). I think...
How do you create auto increment fields in ADOCE? I tried: CREATE table MyTable (ID Int Identity (1,1), Description Text) and CREATE table MyTable (ID Int...
Is this on a sqlce database or a PocketAccess database? I was under the impression that autoincrement fields were not an option for PocketAccess. -- Eric...
Hello everybody! When using varchar do I need to always define a size? What about if I don't know the size? I ask because I'm getting an error when I do the ...
Yes you need to specify the maximum. Make it as large as it might need to be. There is an upper limit, perhaps someone else remembers what it is. ... From:...
I have not tested it on PocketPC databases, but in MS Access the COUNTER keyword does the job. I do not recommend using autoinc fields with ADOCE. Rather,...
We are developed one PPC application using NsBasic CE.In this application successfully installed in all PPC.But Dell Axiom Type of PPC cannot installed in this...
Hi. Try the following proc: After installing both IDE (desktop and device) register the desktop IDE. On the Desktop IDE Help>Register>Set Device It worked for...
