Find in Bankbots (Sdk)

Find in Bankbots // Sdk

1  |  


May 23, 2001, 5:57pm
To: All Avid Users Of Aw,
How do you find the name of an avatar in a database?
I am using data controls, & my bankbot can add accounts, but not find
accounts. Data1.Recordset.FindFirst "Both = 'sdk.awAvatarName'"
Does not work, for I get a NoMatch=True vairable, so it returns the first
record in the database. If I take away the the quotes, I get a Jet error. I
know how to do this in SQL, but how can I utilize SQL with the data control?

Barbarossa (315942)

P.S. To everone that despises programmers like myself (makaveli,grimble), I
take it as my responsablity to duly inform you that I have created my first
bot, so this will be my second. Want It? Telegram me.

m a k a v e l i

May 23, 2001, 6:08pm
*chuckle* good luck on your bankbot *chuckles again*

[View Quote]


May 23, 2001, 9:18pm
Ack! Data controls (I hate them myself, but that's just a personal vendetta
against the horrid things ;o) ).

The data control cannot resolve 'sdk.awAvatarName' into what you expect
because you are providing it as a literal (between the quotes), so it is
looking for the text "sdk.awAvatarName" in the field Both, rather than the
result of the expression. You need to build the string yourself, something
like this:

Data1.Recordset.FindFirst "Both = '" & sdk.awAvatarName & "'"

Then the VALUE AwAvatarName property is added between the two literals "Both
= '" and "'" forming

"Both = 'SnagglePuss'".


[View Quote]


May 24, 2001, 7:50pm
Data controls...they're confusing, and you'd be better off having MS
Acces97... I like doing stuff my own way, so I call my DB files .bdb (stands
for Bot DataBase)... they're simple, plain ASCII files with data separated
with comas (,) and are 1 entry/line

PS. off course, you could do something better, more DB like...

[View Quote]


May 24, 2001, 9:09pm
The MS Jet database engine that data controls, QueryDefs, Recordsets, etc.
use is the same database engine that drives MS Access. Its just another way
to utilise MDB files.


[View Quote]

1  | is a privately held community resource website dedicated to Active Worlds.
Copyright (c) Mark Randall 2006 - 2024. All Rights Reserved.   ·   ProLibraries Live   ·   Twitter   ·   LinkedIn