Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3368: Cannot modify header information - headers already sent by (output started at /includes/bbcode.php:472)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3370: Cannot modify header information - headers already sent by (output started at /includes/bbcode.php:472)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3371: Cannot modify header information - headers already sent by (output started at /includes/bbcode.php:472)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3372: Cannot modify header information - headers already sent by (output started at /includes/bbcode.php:472)
OrbWorks Community Forum • View topic - CE Contact Database

CE Contact Database

Discuss PocketC for CE (including Desktop Edition)

Postby UP on Thu Jan 04, 2001 7:53 pm

How can I get a list of all names and phone numbers from the contact database?

Thank you for useful hints!

UP
UP
 
Posts: 2
Joined: Thu Jan 04, 2001 7:48 pm

Postby Justinespinosa on Sun Jan 07, 2001 11:17 am

It's really easy. Just read the registry value of HKEY_LOCAL_MACHINE\Explorer\Database\ContactsDatabase (PocketC command: regrstr(2,"Explorer\\Database","ContactsDatabase"); ) then read it with the PocketC Database functions. I've never used the database functions but I've changed the name of the contacts database, add new contacts, syncro with the PC then restore the old name (just to check if it where working. But the PC send me the Database i had done for a laugh and i lost all my contacts... <img src=icon_smile_sad.gif border=0 align=middle>

J.Espinosa

OUTS Softwares
J.Espinosa

OUTS Softwares
Justinespinosa
 
Posts: 156
Joined: Wed Dec 06, 2000 2:30 pm
Location: Switzerland

Postby UP on Sun Jan 07, 2001 5:08 pm

My problem was to find out the "keys" for name, phone number and so on...
For example, you can get the name of a record with "dbrecread(31,14865)". And this number (14865) was, what I wanted to know... If anybody is interested: phone number is 14857 and first name is 14854.
UP
 
Posts: 2
Joined: Thu Jan 04, 2001 7:48 pm

Postby rglasmann on Tue May 29, 2001 2:30 am

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
My problem was to find out the "keys" for name, phone number and so on...
For example, you can get the name of a record with "dbrecread(31,14865)". And this number (14865) was, what I wanted to know... If anybody is interested: phone number is 14857 and first name is 14854.


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I;m interested. How do I get the rest of the "keys" for all of the fields in the contact database?

--Ron
rglasmann
 
Posts: 4
Joined: Tue May 29, 2001 2:28 am

Postby rawn shea on Tue May 29, 2001 2:40 pm

Another related question: the database functions do not offer an option to locate database files anywhere other than the database directory: fileenum does not reach into the database directory to list the files there. I am working on a CAd program, and wanted to give the user a pick list for existing "drawings" which are database files. either functionality wo7uld solve the problem. I have not found a solve for either, other than to maintain a text file containing a duplicate of the drawing files, maintained from withiin the database open function. Any other solutions?
rawn shea
 
Posts: 12
Joined: Wed Mar 07, 2001 6:35 pm

Postby Justinespinosa on Tue May 29, 2001 4:25 pm

The first thing you should know is that those databases are not files in a directory. they are somewhere in the memory that is not part of the file system. But there's a function to enumerate the databases. i don't remember it's name but you should find it in the help

J.Espinosa

OUTS Softwares
J.Espinosa

OUTS Softwares
Justinespinosa
 
Posts: 156
Joined: Wed Dec 06, 2000 2:30 pm
Location: Switzerland

Postby rglasmann on Wed May 30, 2001 1:52 am

"dbenum" allows you to get a list of databases on the device by type. If you use "dbcreate" to create your databases for your CAD program, I'd pick a rather "obscure" number for the type. Then you can feel somewhat comfortable using dbenum with your type to just get a list of your databases.
rglasmann
 
Posts: 4
Joined: Tue May 29, 2001 2:28 am

Postby rglasmann on Wed May 30, 2001 1:55 am

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
My problem was to find out the "keys" for name, phone number and so on...
For example, you can get the name of a record with "dbrecread(31,14865)". And this number (14865) was, what I wanted to know... If anybody is interested: phone number is 14857 and first name is 14854.


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I;m interested. How do I get the rest of the "keys" for all of the fields in the contact database?

--Ron

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

In case this is not clear, I am looking for a way to get the "keys" or property ids for all the properties used in the Contacts database. I am working on a program that will import and export data out of the Contacts database and can't come up with a reliable way to do it without the property ids. Any ideas?
rglasmann
 
Posts: 4
Joined: Tue May 29, 2001 2:28 am

Postby goodey on Wed Jun 13, 2001 7:05 pm

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
My problem was to find out the "keys" for name, phone number and so on...
For example, you can get the name of a record with "dbrecread(31,14865)". And this number (14865) was, what I wanted to know... If anybody is interested: phone number is 14857 and first name is 14854.


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I;m interested. How do I get the rest of the "keys" for all of the fields in the contact database?

--Ron

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

In case this is not clear, I am looking for a way to get the "keys" or property ids for all the properties used in the Contacts database. I am working on a program that will import and export data out of the Contacts database and can't come up with a reliable way to do it without the property ids. Any ideas?


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
here is a list of most of the feilds on my palm-size PC
14856=Work Tel
14857=Home Tel
14876=Mobile Tel
14878=Car Tel
14884=Work Fax
14885=Home Fax
14895=Home2 Tel
16388=Asst. Tel
16391=Work2 Tel
16393=Pager
16458=Other Street
16459=Other City
16460=Other State
16461=Other Zip
14853=Suffix
14854=First Name
14865=Last Name
14870=Company
14871=Title
14872=Department
14873=Office Location
14877=Radio
16386=Assistant
16390=Children
16392=Web Page
16394=Spouse
16403=File As
16419=Mr/Mrs/Dr
16420=Middle Name
16448=Home Street
16449=Home City
16450=Home State
16451=Home Zip
16452=Home Country
16453=Office Street
16454=Office City
16455=Office State
16456=Office Zip
16457=Office Country
16462=Other Country
16515=Email1
16531=Email2
16547=Email3

17175=(Reserved Code #)

Israel Vish
Israel Vish
goodey
 
Posts: 24
Joined: Wed Jan 17, 2001 10:34 pm
Location: USA

Postby rglasmann on Thu Jun 14, 2001 1:16 am

Excellent! Thanks. I'm curious. How did you get them?
rglasmann
 
Posts: 4
Joined: Tue May 29, 2001 2:28 am

Postby goodey on Thu Jun 14, 2001 5:06 pm

I dont remmember exactly.
but I did something like this I made a program that made arecord in the contac database & tries to write each field # into its field then I went to that record in the contacts program & was able to see each field had its # writen in it.

Israel Vish
Israel Vish
goodey
 
Posts: 24
Joined: Wed Jan 17, 2001 10:34 pm
Location: USA

Postby Joe on Fri Jun 29, 2001 12:38 am

I have a problem with the dbrecread(31,propID) on an invalid propID, where the app will just quit quietly. This problem only appear on the proptype of 31, others proptype is OK where it return 0, even though the propID is not valid.

e.g.
main(){
int dbID, recID, ctr;
dbID=dbopen(0,?¢‚Ǩ
Joe
 
Posts: 4
Joined: Mon Jun 18, 2001 12:14 am

Postby goodey on Fri Jun 29, 2001 3:09 pm

I remmember coming across this problem a while ago while I was still using Version 2.
I was told at the time that in version 3 it will be corrected. I dont know if it was but if your using version 3 then abviously it wasnt.

Israel Vish
Israel Vish
goodey
 
Posts: 24
Joined: Wed Jan 17, 2001 10:34 pm
Location: USA

Postby Joe on Sun Jul 01, 2001 11:55 pm

I am having Ver. 3.0
Joe
 
Posts: 4
Joined: Mon Jun 18, 2001 12:14 am

Postby WhollyMindless on Fri Jan 04, 2002 2:28 am

Question:

The enumeration example shows it returning the internal databases. When I run it the initial call returns 0 telling me I have no databases.

Is there something I'm missing?

WhollyMindless

(Code Follows)

main()
{
int ret;
int oid;

showconsole();

ret = dbenum(0,1);

putsl("db enum "+ret);

if (ret == 0) return;

while ((oid=dbenum(0,0))!=0)
{
putsl(dbname(oid)+" "+
dbsize(oid)+" "+
dbnrecs(oid));
}

}
WhollyMindless
 
Posts: 2
Joined: Fri Jan 04, 2002 2:18 am

Next

Return to PocketC for CE

Who is online

Users browsing this forum: No registered users and 3 guests

cron