Ultralite Query Help
I am using ASA v 188.8.131.5285 and I am developing for Palm.
I am creating a filter in place that allows the user to
filter the resulting list based on 3 criteria. Each of the 3
criteria has a "Select All" option and several other
When "Select All" is chosen this effectivly removes this
criteria from the query. I am trying to devise the most
efficient way to write my ESQL. Te
EXEC SQL DECLARE MyCursor CURSOR FOR
SELECT * from MyTable where criteria1 = c1 and criteria2 =
c2 and criteria3 = c3;
This works if all three selections are mad...about ultralite
Can i develop a ultralite program not using sybase asa database,
can i using sql server or oracle directly..
> Can i develop a ultralite program not using sybase asa database,
> can i using sql server or oracle directly..
I think, you need asa just as a reference database, used by UltraLite,
generating the source files etc. But with a working UltraLite application,
which has a similar schema like your database (MSSQL, ORA etc.), you can use
the MobiLink server to synchronize with.
I want to gather some information about UltraLite from these forum.
1) What tools or language can develop a UltraLite application?
2) Can you tell me the size of a general UltraLite application?
3) How to calculate the licences fee of a UltraLite database engine and the
Thanks in advance,
E-mail : firstname.lastname@example.org
>1) What tools or language can develop a UltraLite application?
UltraLite supports C/C++ and Java. If you are developing for WinCE then
the supported compiler is Visual C. If you are developing for t...Ultralite
Is it possible, by any means to open an .udb file from powerbuilder 10.2
either programmatically or from the database painter???
Maybe installing some kind of drivers as an example..
Thanks in advance,
...Ultralite Project query
I need to add a Sybase statement to the Ultralite project that reads -
SELECT Name FROM Table WHERE Name LIKE '%abc%'
where abc needs to be passed in at runtime in the placeholder ?.
Can the above query be entered as:
SELECT Name FROM Table WHERE Name LIKE '%?%'
Will this work?
Please help me,
preeti wrote in news:22498C8C06CE1580005ED1EB85256CC6.005ED1FB85256CC6
> SELECT Name FROM Table WHERE Name LIKE '%?%'
No, I think you would do this:
SELECT Name FROM Table WHERE Name LIKE ?
Then when y...How to set value of datetime in ultralite?
My platform is MobileBuilder 2.0.933 + PalmOS 3.5 + ASA 184.108.40.2066.
I try to use ULBSetDateTime(ULDatabaseDBtohost, toclient_create_date,
&datetime) to set the value of a table column. But I can't pass the
compilation. The 3rd parameter is not correct. I tried other types but
failed. Could someone give me an advice?
Thank you for your help
Show us how you declared each of the 3 parameters that you used.
Certified SQL Anywhere Associate
Sybase - iAnywhere Solutions
Please only post to the newsgroup
h...Wrong Ultralite query results!
There seems to be a problem getting right results from a query in Ultralite
DB on WinCE. V 7.0.2
Following statement works fine in the Windows emulation environment but not
on the WinCE ARM target!
SELECT * from customer WHERE name LIKE ? ( name is a char )
For the ? we set 'S%'. After opening the query and trying to get through
the results with Next() the Ultralite Library throughs an exception ( I do
not know which one ) and skips the following code!
The same code is working with a numerical field like:
SELECT * from customer WHERE number LIKE ? (...Running MobileVB Ultralite 8 application in Windows after installing Ultralite 9
I have 3 applications. I developed my first 2 using
Ultralite 8 technology. For my 3rd, I installed Ultralite 9
so I could use use dynamicSQL. In MobileVB, under
Project,References, I can see both "iAnywhere Solutions
Ultralite for MobileVB 8" and "iAnywhere Solutions Ultralite
for MobileVB 9". So everything is installed correctly.
When I want to run my 1st or 2nd application in
Windows(using db connection techniques for UL 8), I can't
run the app. I get errors because it wants me to use the
UltraLite 9 database connection syntax.
I do not understand...A problem about Datetime format between Oracle with UltraLite
When I Synchronize UltraLite with Oracle 8.1.7, I got a error:
E. 12/26 00:18:39. [sys]: Error: ODBC: [MERANT][ODBC Oracle 8 driver]Invalid
datetime format. Error in parameter 4. (ODBC State = 22007, Native error
code = 0)
E. 12/26 00:18:39. [sys]: Error: Unable to insert into table "PWQK" using
I. 12/26 00:18:39. [sys]: The error is as follows:
sqlcode = 0
odbc_state = 22007
message = ODBC: [MERANT][ODBC Oracle 8 driver]Invalid
datetime format. Error in parameter 4. (ODBC State = 22007, Nat...Problem of setting datetime value in Ultralite
I still has the problem of setting datetime value in Ultralite.
According to your help, my code is defined below:
dt.year = 1992;
dt.month = 10;
dt.day = 11;
dt.hour = 10;
dt.minute = 20;
dt.second = 3;
dt.microsecond = 0
bOK = ULBSetDateTime(ULDatabaseDBtohost, tohost_create_date, dt);
DisplayNotice("Can't update!", "OK", "");
I pass the compilation, but fail to run. The ULBSetDa...PPB and Ultralite<->ASE with publications
Thanks guys - upgrading latest EBF on ASA and PBB got me up and running....
Now for the next question, hope I'm able to explain this properly
I've made a sync object for Ultralite with the wizard, and tried to write
some code that syncronize a single table in a UltraLite shceme. I've
similar code in Java that successfully does the sync. Now the PB-code is
SQLCA.DBMS = "TRACE UL9"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DBF=C:\ulite\tnt.udb;UID=dba;PWD=sql'"
Connect using SQLCA;
nvo_ulite_ulsy...Ultralite plan ( query performance problem)
I have a query on the Ultralite database which runs pretty slow,
number of rows in each table:
MS_REP_SALES_SUM: 6000 ( 3000 of which qualify for the join in the query
If i have the MS_REP_SALES_SUM table empty in my UL database, the query
runs in less than 10 seconds.
The query is a 3 table outer join, MS_REP, MS_REP_SALES_SUM,
SELECT R.REP_ID, R.FIRST_NM, R.LAST_NM, R.STATE_ID, R.PRIM_PHONE,
R.PRIM_PHONE_EXT, R.FIRM_NM, ISNULL(A.AUM_AMT,0), ISNULL(S.REDEMPTIONS,0),
ISNULL(S.TRADE...Issues migrating from .NET Ultralite 9.0 API to Ultralite 11.0 API
The query is regarding migrating from UltraLite 9.0 API to
UltraLite 11.0 API
We have written a .NET component which performs the
synchronization operation; this was initially written using
the UltraLite 9.0 and .NET Compact Framework 2.0.
We now migrated this component to .NET Compact Framework 3.5
and UltraLite 11.0, while doing this there where some
methods and properties which were missing in the new version
of UltraLite API 11.0 as seen below; due to which we are
unable to compile this component.
I tried searching the Sybase knowledgebase for any help
regarding this but u...UltraLite: Problems with SQL key words in query
I've got a problem with querying my UltraLite database. Unfortunately I've
got to use a database schema which I cannot change and which has got some
tables with conflicting column names like "GROUP", "COMMENT" and so on. E.g.
"ShoppingBasket"."Group" or "UserComments"."Comment".
Anytime I want to bind one of these tables my UltraLite database to an .NET
form I get an error because of the conflicting column names. If I leave
exclude these columns from my query everything works fine.
I've tried seve...