MAD52

Well, I found this site yesterday and it is a great place. I jusdt bought an X50 basic, the first pocket I have. I'm learning to use it, but I found that it only has word and excel, it doesn't have access. So after reading microsoft didn't make any version of access, so try some trial programs like sprint db, abc, and a couple more. I'm learning to use some sql commands in my class, so I tried to do it in my pocket. I make a simple table, with only 5 registers, and try to make the consult in sql. I have 15 to do, so start with the first one. I'll do first in my pc, in access 2003 and all where ok. So I tried then in my pocket. I tried the first and the second and where ok, but when I tried the third it gives me error in sql command. First I think the program was working bad, so I tried another, and another, all give me the same error. But in my pc it works, so I know my command was written ok. I saw that not all commands are allowed in ppc, so I think that is the problem, but lloking further I know where the error is located in the command. The problem is it can't let me to multiply. Because it thinks that * means comodin or all, not multiply. So how can I multiply ? I tried with ( ) and the same error, any ideas? Which program do you recommend me? Thanks for your help.

MAD52

So, no one use sql commands in a databse pocket pc program?

coolabah

Originally Posted by MAD52

So, no one use sql commands in a databse pocket pc program?

Not sure if this is what you are looking for, and don't know too much about it (it didn't suit my purposes as you have to convert from native file format, so I un-installed the trial after a few minutes)
Pocket Database Viewer Plus(mdb,xls..) 2.5

"Apply filters, Sort Orders or apply any SQL Select query to get database contents."

http://www.pocketgear.com/software_detail.asp?id=11076

Sean P

Suggest you give this a try its free :) I have found it useful.

www.grandasoft.com/default.aspx

Regards

psionandy

Originally Posted by Sean P

Suggest you give this a try its free :) I have found it useful. www.grandasoft.com/default.aspx Regards

It is very good.. but it's not realy a relational database is it?

(but for the price it is hard to beat :) )

__________________
You'd have thought that someone would have put a sig here
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

MAD52

Well I'll try to explain better. This is the SQL query that I want to run and give me the error: (80040E14) The command contained one or more errors.
SELECT *
FROM DETALLE
WHERE cantidad*precio_unitario >100;
DETALLE is the name of the table. cantidad and precio_unitario are valid fields. So what I try to do is to multiply the value in cantidad and the value in precio unitario, and then it only shows it to me if it is more than $ 100. If anyone wants I can also give some numbers to try. I run in Access 2003 without any problem, but can't in every pocket db program I try. Any ideas?

Kenster

Look at:

http://www.vieka.com/esql.htm

which purports to be a freeware SQL engine. I haven't used it myself, but thought of you in my web surfing ...

MAD52

Well I try it but it close and goes to today screen. And for what I see is more like programming, I don't need something like that, I only need something like access with a sql view to make your query, that's all. There must be a program that simple or at least someone tell me if you can multiply with sprint db.