flat assembler
Message board for the users of flat assembler.

Index > Projects and Ideas > sqlite wrapper dll for visual basic 6

Author
Thread Post new topic Reply to topic
vbVeryBeginner



Joined: 15 Aug 2004
Posts: 884
Location: \\world\asia\malaysia
vbVeryBeginner 31 Aug 2006, 12:34
yo yo yo
presented is sqlite wrapper dll coded in fasm to be used in visual basic 6.
http://www.boinc.ch/~sleepsleep/bbimg/sqlitedll.zip

i used heap and lstrcpy heavily Laughing Laughing Laughing anyway, it should works as expected.

and i coded a sqlite db browser (sorry, using vb6) so that i can show how to use the wrapper dll. Wink
Image

more info here http://www.boinc.ch/~sleepsleep/viewtopic.php?t=91

coz i always use other people coded wrapper dll, and i always want to make one myself, now i got my own one Laughing Laughing feel really happy Cool

h a p p y c o d i n g Wink
ps: the db structure is what i used to do the cybercafe application.
Post 31 Aug 2006, 12:34
View user's profile Send private message Visit poster's website Reply with quote
HyperVista



Joined: 18 Apr 2005
Posts: 691
Location: Virginia, USA
HyperVista 31 Aug 2006, 12:51
yo vb - awesome! congrats!!! Now I understand your recent posts about being happy to learn and poll on being happy with your code.

BTW, very nice looking interface.
Post 31 Aug 2006, 12:51
View user's profile Send private message Visit poster's website Reply with quote
f0dder



Joined: 19 Feb 2004
Posts: 3175
Location: Denmark
f0dder 31 Aug 2006, 13:11
Cute Smile

Just be a bit careful with lstrcpy - buffer overflows and all.
Post 31 Aug 2006, 13:11
View user's profile Send private message Visit poster's website Reply with quote
vbVeryBeginner



Joined: 15 Aug 2004
Posts: 884
Location: \\world\asia\malaysia
vbVeryBeginner 31 Aug 2006, 13:29
thank you guys
the vb code for my cybercafe app is even more awesome :p :p,
the dll source is awesome too ~ in term of style (at least for me to feel the awesomeness myself Very Happy Very Happy ~ i really like it)

the vb sqlite browser is simply a little bit sketch just to make the browser works (coded it today), no plan to improve it :p.

i think i wanna code a STOCK in/out application soon. maybe not using vb6, but complete fasm Smile or maybe i should code a full fasm sqlite browser? so that it could integrate with future application? :p
Post 31 Aug 2006, 13:29
View user's profile Send private message Visit poster's website Reply with quote
Madis731



Joined: 25 Sep 2003
Posts: 2139
Location: Estonia
Madis731 01 Sep 2006, 06:52
:clap: :clap: :clap:
Even from the look of it - nice. I think I'm gonna test it though and give a little more precise answer than just great Wink
I can't wait to try...bye!

EDIT: That VB app is nice - I like the clickable system to make the sentences (y) only I needed to put the VALUES properly before it gave me results. The errors weren't very descriptive Smile
I understand that this is just a demo and anyone can make it better Wink Pretty polished already.
Post 01 Sep 2006, 06:52
View user's profile Send private message Visit poster's website Yahoo Messenger MSN Messenger Reply with quote
vid
Verbosity in development


Joined: 05 Sep 2003
Posts: 7105
Location: Slovakia
vid 08 Sep 2006, 07:42
why is the wrapper DLL needed? VB can't use original DLL, or is it some "helper" or what?
Post 08 Sep 2006, 07:42
View user's profile Send private message Visit poster's website AIM Address MSN Messenger ICQ Number Reply with quote
vbVeryBeginner



Joined: 15 Aug 2004
Posts: 884
Location: \\world\asia\malaysia
vbVeryBeginner 08 Sep 2006, 12:51
yo yo vid,
VB cannot call (original) dll that use CDECL calling during developement mode, but work after u compile the vb project and run.

so, this wrapper dll (coded in fasm) is to provide a way for VB users to use the dll even in developement mode. and it is a "helper" in some way.

@madis731
thank you Smile
maybe someday somebody can code the sqlite browser using fasm Smile
Post 08 Sep 2006, 12:51
View user's profile Send private message Visit poster's website Reply with quote
wisepenguin



Joined: 30 Mar 2005
Posts: 129
wisepenguin 08 Sep 2006, 13:13
if you make a typelib of the SQL functions you wont need
the fasm DLL wrapper.

VB can call cdecl functions from a typelib
Post 08 Sep 2006, 13:13
View user's profile Send private message Reply with quote
Filter



Joined: 08 Oct 2006
Posts: 67
Filter 22 Oct 2006, 18:51
If you upgrade to VB 2005 you can use an ADO.NET provider...

http://sqlite.phxsoftware.com/

I used it for one of my personal projects (C# 2005)...

http://www.box.net/public/6f6z96z93g

This project isn't even near complete but it is stable.
Post 22 Oct 2006, 18:51
View user's profile Send private message Reply with quote
Display posts from previous:
Post new topic Reply to topic

Jump to:  


< Last Thread | Next Thread >
Forum Rules:
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Copyright © 1999-2025, Tomasz Grysztar. Also on GitHub, YouTube.

Website powered by rwasa.