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
Page 1 of 2

PostPosted: Thu Jan 04, 2001 7:53 pm
by UP
How can I get a list of all names and phone numbers from the contact database?

Thank you for useful hints!

UP

PostPosted: Sun Jan 07, 2001 11:17 am
by Justinespinosa
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

PostPosted: Sun Jan 07, 2001 5:08 pm
by UP
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.

PostPosted: Tue May 29, 2001 2:30 am
by rglasmann
<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

PostPosted: Tue May 29, 2001 2:40 pm
by rawn shea
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?

PostPosted: Tue May 29, 2001 4:25 pm
by Justinespinosa
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

PostPosted: Wed May 30, 2001 1:52 am
by rglasmann
"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.

PostPosted: Wed May 30, 2001 1:55 am
by rglasmann
<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?

PostPosted: Wed Jun 13, 2001 7:05 pm
by goodey
<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

PostPosted: Thu Jun 14, 2001 1:16 am
by rglasmann
Excellent! Thanks. I'm curious. How did you get them?

PostPosted: Thu Jun 14, 2001 5:06 pm
by goodey
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

PostPosted: Fri Jun 29, 2001 12:38 am
by Joe
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,?¢‚Ǩ

PostPosted: Fri Jun 29, 2001 3:09 pm
by goodey
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

PostPosted: Sun Jul 01, 2001 11:55 pm
by Joe
I am having Ver. 3.0

PostPosted: Fri Jan 04, 2002 2:28 am
by WhollyMindless
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));
}

}