Hi all

The ODBC examples I have seen all stops at retrieving data.
Here is an example that includes add, modyfy and delete.

KetilO
Posted on 2004-06-21 08:32:38 by KetilO
Thak you Ketil, you always sharing the best.
What about find records? One examples will be appreciated.

regards
ipadilla
Posted on 2004-06-21 11:14:53 by ipadilla
Hi

I make one program that has update and search too, but it is only on Croatian language. Program has 14 fields. If someone need it i can send.

stanks
Posted on 2004-06-22 02:35:26 by stanks
Thank you Stanks,

you are very kind. You can post it here or send it to my addresshttp://www.asmcommunity.net/board/cryptmail.php?tauntspiders=in.your.face@nomail.for.you&id=8f3bfe7c0258725be5e28b8c8874144d.


Thanks again
ipadilla
Posted on 2004-06-22 04:18:52 by ipadilla
If you need i will try to translate field names. Toolbar buttons from left to right: Add new record, Edit record, Delete record from DB, Search (or Find), Load all records from DB, Exit. Menu from left to right: File, Search, Help File menu: all menu items mean same as toolbar buttons (in that order). Status window: Current number of records in DB.

stanks
Posted on 2004-06-22 07:21:28 by stanks
Stanks,
Ok, if you can translate it would be very helpfull.
Thank you very much indeed.
ipadilla
Posted on 2004-06-22 08:29:37 by ipadilla
Menus, messages, dialogs....translated to english. Enter some record with all fields and then you can change (translate) all fields in db. If you do so, then don't forget to translate this fields in inc file. Fields in SQL statements.

stanks
Posted on 2004-06-22 10:51:55 by stanks
Thank you Stanks,

now I can understand your program, very nice and interesting to learn.

If you like database programming, please visit this site http://greenant.altervista.org/.
where you can find a really good example.

regards
ipadilla
Posted on 2004-06-22 23:06:26 by ipadilla
The database program is Gremaf.
It uses a database to store all information read from MAME.

I have another example, not in my site, about database programming. It's a sort of cd organizer.
It is written in C++ but uses only win32 api, and odbc, and is simple to understand even if you don't know c++.
I can unpload this program if someone want it
Posted on 2004-06-23 01:30:44 by greenant
Hi stanks,

Please, what versi?n of MASM32 are you using to build DVD-Katalog?.
After Translate it to English, I am tring to compile it, but
the following fonctions are missed.

C:Masm32Includedebug.inc(256) : error A2006: undefined symbol : dwtoa
DVD-Katalog.asm(63) : error A2006: undefined symbol : szCopy
DVD-Katalog.asm(64) : error A2006: undefined symbol : szLen
Also this symbol:
DVD-Katalog.asm(982) : error A2006: undefined symbol : TTN_GETDISPINFO

Can you help me, please?

Regards
ipadilla
Posted on 2004-06-27 23:07:00 by ipadilla

Hi stanks,

Please, what versi?n of MASM32 are you using to build DVD-Katalog?.
After Translate it to English, I am tring to compile it, but
the following fonctions are missed.

C:Masm32Includedebug.inc(256) : error A2006: undefined symbol : dwtoa
DVD-Katalog.asm(63) : error A2006: undefined symbol : szCopy
DVD-Katalog.asm(64) : error A2006: undefined symbol : szLen
Also this symbol:
DVD-Katalog.asm(982) : error A2006: undefined symbol : TTN_GETDISPINFO

Can you help me, please?

Regards
ipadilla

Latest v8 of MASM with SP1 and older v1.21 of windows.inc I check new v1.26e of windows.inc and there is TTN_GETDISPINFO as it is in v1.21 dwtoa, szCopy and szLen are from masm32.lib Do you have it in your masm32lib directory?
From windows.inc:
TTN_FIRST equ 0-520
TTN_LAST equ 0-549
TTN_GETDISPINFO equ TTN_FIRST
Try to remark lines in inc file include masm32.inc and includelib masm32.lib. Maybe this is the problem.

:confused: :sweat: :rolleyes:

stanks
Posted on 2004-06-28 00:36:48 by stanks
Hi stanks,
I am finishing an English translation and I will send you a copy soon.
Please would you be so link of translate to Englist the literal meanigs
of the following Labell, variables en fonctions.

Labell:
ZaUpdate:
PrekoBrisanja:


variables:
obavezno
ZagradaO
duljinaKompStringa
duljinaStringaPolj
Odabir
UcitajIN
SnimiINI
-----Duljina
ImePolja* (where * = 1,2,3,4,5...)
PrviPuta
RaznoSection

Fonctions:
UbaciUOdredjeniStupac

Your examples will be very usefull for this Community Borad, if
you want post it after translation

Thank you very much endeed.
ipadilla
Posted on 2004-07-06 08:35:09 by ipadilla
Hi ipadilla

Here is the translation:

ZaUpdate: -> i give it wrong name on my language :) but you can change it to UpdateContinue or similar
PrekoBrisanja: -> OverErasing or similar (erasing contest of edit boxes)
obavezno -> give any name you want...only info ti user
ZagradaO -> give any name you want...it is char '('
duljinaKompStringa -> LengthOfCompleteString
duljinaStringaPolj -> LengthOfStringOfField or similar
Odabir -> this is procedure that is not yet finished because i didn't make any code for it. But in the future
the user will choose (on first time run) type of DB he wants. IBM DB2, MySQL, MS Access and Oracle. You can
translate name of this procedure to ChooseDB.
UcitajINI -> LoadINI
SnimiINI -> SaveINI
-----Duljina -> Length (size in chars) of every field
ImePolja* (where * = 1,2,3,4,5...) -> FieldName
PrviPuta -> FirstTimeRun
RaznoSection -> Razno=Other
UbaciUOdredjeniStupac -> PutInExactColumn (or set or inject or similar)

I hope too that people will find this examples useful
If you need more help...im here.

stanks
Posted on 2004-07-06 12:03:48 by stanks
Hi stanks,
please would you be so kind to translate that?. With this we will fishish the translation.

1 "Komedija"
2 "Horor"
3 "Akcija"
4 "Dje?ji"
5 "Znanstveno-fantasti?ni"
6 "Triler"
7 "Kriminalisti?ki"
8 "Psiholo?ki"
9 "Crtani"
10 "Animirani"
11 "Povijesni spektakl"


"MicroSoft Access baza" (only baza)
"&Prihvati"
"&Odustani"

"Prvi puta pokre?ete program zato prije samog kori?tenja programa izaberite tip baze sa kojom ?elite raditi. Mo?ete koristiti samo JEDAN tip baze! Svi ostali tipovi baza biti ?e automatski izbrisani zato pripazite kod odabira."

Thank you
ipadilla
Posted on 2004-07-07 00:23:15 by ipadilla
I think these questions really about translation but I really thank you about your sharing. I hope ODBC example will be OK.
Posted on 2004-07-07 07:07:55 by PuLsAr
Hi ipadilla

For movie genres you can set this:

Spy
Romance
Children-Family
Historical
Epic
Western
Comedy
War
Musical
Horror
Mystery
Crime
Adventure
Fantasy
Science Fiction
Drama
Action
Thriller
Porn


"MicroSoft Access baza" (only baza) -> database
"&Prihvati" -> OK (or Accept)
"&Odustani" -> Cancel

This is only message for user when he will choose DB type on first time run.
You can set this translation:
"This is your first time to run this program. Choose type of DB. You can choose only ONE type!
Every other type will be deleted so be careful."
"Prvi puta pokre?ete program zato prije samog kori?tenja programa izaberite tip baze sa kojom ?elite raditi.
Mo?ete koristiti samo JEDAN tip baze! Svi ostali tipovi baza biti ?e automatski izbrisani zato pripazite kod odabira."

stanks
Posted on 2004-07-07 12:21:26 by stanks
Hi stanks,
I am having problems with the following conditions, after translation:

.if word ptr =='aD'
invoke CheckDlgButton,hNovi,IDC_CHK1,BST_CHECKED
.endif
.if word ptr =='aD'
invoke CheckDlgButton,hNovi,IDC_CHK2,BST_CHECKED
.endif

even you second post with partial translation fail.

Can you explain me what is 'aD' ?. I can not understand it.
Your croata versi?n works fine.
Thanks
ipadilla
Posted on 2004-07-09 00:29:47 by ipadilla
This is reverse 'Yes' (Da -> aD) on croatian language and 'Ne' is 'No' (Ne -> eN).

stanks
Posted on 2004-07-09 10:58:59 by stanks
Hi All,
As far as I know there is not too much examples about database programming on MASM32 Forums.
I do not know what the reason but until some time ago, Ezc?s example was the unique interesting.

Recently, I have seen some good works about this kind of programming (ie.: Biterider and NaN), but the level is too hight for nebies, althought these works are the best on Internet.

Ketil Olsen, Greenant and Stanks wrote good examples in easy MASM32 for nebies.
That the reason why I decided to translate this Croatian example code by Stanks, who help me a lot in this translation to English.

This small translation is not perfect, but I think that it dose not matter, the most important aspect is that a lot of people can undestarding it, because in croatian languagues was dificault too follow it. If you find any bug, possibly is my responsibility because the croatian version work fine under w2k and winXP.

If my translation is usefull for some people I will be happy. But remember, the author is Stanks. Please, see copyright on help menu (about...).

Thank you Stanks for this nice ODBC example.

Known bug:
I have problems editing records under Windows millenium and Windows 98 SE, but works perfectly under w2k and winxp. If I have time I will check this possible bug next week. If somebody want collaborate, welcome.

ipadilla
Posted on 2004-07-11 10:57:42 by ipadilla
Hi

Everyone forget this copyright. This was just....hm...this wasnt serious. If you find this example useful...great. And thanks a lot ipadilla for translating to english...and yes croatian language is very hard as every slavic language is.

stanks
Posted on 2004-07-11 14:17:28 by stanks