At 8:52 PM +0200 4/30/04, a dot kuiper7 at chello dot nl wrote:
creating an index in a RealDatabase with a lookalike statement like this:
RBDB.SQLExecute("Create index oeidx on vw (oenr)")
causing the IDE and also the build application to crash and trying to sent a
'loveletter' from drWatson to Bill Gates?
Let me make sure I understand: you're saying that executing a bit of
code (an SQLExecute call) in your running app, causes the IDE itself
to crash?
When copying a double value from one database to an integer field in another
database with this statement:
r.Column("IntVarField")=XLDBrecords.IdxField(i+1).Value
only the first digit is copied into the integer field.
So the double 1788,0 becomes 1 and the double 245869,0 becomes 2 !!
As you can see in this statement the value is read as a variant from the
sourcedatabase and should IMO been converted to an integer because the
destinationfield is an integer.
There is no way the compiler could now that r.Column("IntVarField")
is an integer -- and in fact it is not; it is a variant. I'm not
sure exactly what's going on here, but relying on the weakly-typed
methods is never a good idea if you can help it. Try it this way:
r.Column("IntVarField").IntegerValue = XLDBrecords.IdxField(i+1).IntegerValue
Does that work?
Problem 4:
Anyone knows a way to show the existing indexes in a RealDatabase from wthin a
program?
There is no documented way to do that. Unofficially, you could open
up the folder or virtual volume that is the RB database, and look for
.idx files.
Did you notice the RealDatabase works in this RB-version? OK it's not perfect
but it's a start!!
That's good. :) Please be sure to report any problems you find via
the feedback system (a posting here does not constitute a report).
Thanks,
- Joe
--
,------------------------------------------------------------------.
| Joseph J. Strout REAL Software, Inc. |
| joe at realsoftware dot com http://www.realsoftware.com |
`------------------------------------------------------------------'
_______________________________________________
Unsubscribe:
<http://support.realsoftware.com/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|