C++ Builder - ADO (Database connection)

[@Neroriller]

Чудове відео, написав по ньому частину курсової)

[@endlicheripolypterus9185]

Thank you very much. It's really helpful for me. I long for another video clips here.

[@luisbrujo77]

Thanks for the video, I learned lots of tips.

[@Alfa_Mogador]

Can you use one treeview and one tdbgrid in place of tdbgrids?

[@vclexamples]

Jet 4 OLE is only for 2000-2003 Access database. Also, check fields that you write into. You cannot write into ID if it is AutoNumber type.

[@ronnason5596]

I have tried everything you've done. I have the database in the same folder as all program files. I keep getting an error that access to the .ldb file is denied. Thought it was the debugger, because it will run without, the debugger, but writing to the database is still blocked. I moved everything to the public folder to see if this would work. Same error. tADO Connection is default denyNone. Lock is lock optimistic.

[@vladislavkovachev6974]

Hello , Thanks a lot for this video!

[@vclexamples]

You should connect to that db table and use Locate function to search for the record you need.

[@buisonmarathoner]

Thank you so much! Do you know how to connect with SQL Sever?

[@vclexamples]

It is the same as for access. Just use the different connection string (SQL Server provider).

[@5Ccosenza]

how I manage the relationship one to many of the dataset? MasterSource allows me to enter only one datasource... Example: Book-Borrowed-User. In Borrowed,in addition to ID BOOK,will go USER ID also. How can I do?

[@vclexamples]

There can be only one MasterSource. Other foreign keys should be entered manually (OnNewRecord event or so...) and to filter those records manually if needed.

[@5Ccosenza]

Thank you so much. I'll try!

[@5Ccosenza]

Practically I have a table "treatment booked" (with ID Treatment, ID Reservation) that I have to relate to the table "Reservation"(with ID Reservation, Hour, Date...) and "treatment"(with ID Treatment, description....). Then: ON NEW RECORD: {TTreatmentBooked-> MasterSource = DReservation; TTreatmentBooked-> MasterFields = "ID_Reservation"; } For Table "Treatment" I set with field link designer in object inspector. I would that to click the record in my grill filtering only connected record(as happens in the correct way to Treatment).

[@vclexamples]

You don't need to specify MasterSource inside event. You can just say TTreatmentBooked->FieldByName("ID_Reservation")->AsInteger = TReservation->FieldByName("ID")->AsInteger. Same for the second table.

[@5Ccosenza]

hello, can you help me with this problem? i use DBcombobox to choice a client by TCLIENT table. I need that when user select a client by name, combobox will return his primarykey. How can i do that? here is my code DBComboBox1->Items->Add(ADOQuery1->FieldByName("Cognome")->AsString+" "+ADOQuery1->FieldByName("Nome")->AsString); Obviously ADOQuery1 has a field CodiceCliente

[@narasimharaopv2283]

Hi, i am trying to retrieve bytes stored in image datatype, sql server using ado. Can you please tell me which ado datatype I have to use for that ? How to retrieve those bytes of data ? Thank you very much in advance.

[@vclexamples]

***** To save bytes you need to use TStream objects. For example: TStream* BlobStream = ADOTable1->CreateBlobStream(ADOTable1->FieldByName("BMP_Picture"), bmWrite); It similiar for reading.

[@narasimharaopv2283]

Hi, Thanks for your post. Can you please help me with the issue...I am trying to load oracle xmltype data using ADO. For that, I am using adLongVarChar as ADO datatype. But with this type, I am able to insert only files having 4k characters, if then file is more than 4k...it fails with ORA-01461 error. Can you tell me which datatype to use for oracle xmltype ? If there is no such datatype...then any other way ? Thanks in advance.

[@vclexamples]

Try using varbinary type. Save/load file streams directly in that field type.

[@narasimharaopv2283]

VCL Examples Thanks for the quick response. Can u please give me more detail/overview. I am using variant(which is assigned with data), in createparameter. Tried variant.changetype to convert it into binary....but its not working :(

[@vclexamples]

***** It's a bit more complex then that. Try searching google for "blob fields oracle".

[@narasimharaopv2283]

VCL Examples I tried many ways...but no luck. Thanks for your quick support. Have a nice day.

[@vclexamples]

***** Maybe i'll record a video about it soon...

[@realamour]

i have a database with access(table"N_name_Picture_picturedresse") and i want to creat a program that when i give him name it give me Picture of that name so pleas give the instruction i use this

[@liliasara4489]

Thanks😊🎉

[@lordjim9971]

How to insert new record to Borrow table?

[@vclexamples]

It's the same as for the other table. Just use the TBarrow (TADOTable).

[@theanh7309]

Hello, do you have a method to connect to MS Access database protected by password? thank you so much!

[@vclexamples]

In that case password should be a part of connection string.

[@ВикторКалмыков-у2н]

ty

[@HugoVillanueva]

:D good video :3 i learn a lot

[@girarthluchajaniaina2403]

Please, I need following this code: Application->MessageBox(Text.w_str(), UnicodeString("Error saving record!").w_str(), 0 | MB_INCONEXCLAM.........

[@veselinjokanovic3032]

Programiranje? Odakle si druže? :D

[@vclexamples]

+Veselin Jokanović Zagreb

[@andreja107]

Znao sam da si sa Balkana,prepoznao sam ti akcenat. Poz iz Srbije i nastavi sa odlicnim snimcima,jako lepo objasnjavas :)

[@vclexamples]

Hvala ;)

[@MDFireX5]

can you record in internet this program ?

[@amkop6695]

Izvini prijatelju trebao bi za maturski rad napraviti nesto kao bibilioteku. Trebaju mi opcije uclani se, izclani se, podigni knjigu, vrati knjigu, unesi knjigu, izbaci knjigu, pogledaj listu knjiga, pogledaj listu ljudi, trazi ljude, trazi knjige.... da li cu moci ako skontam ovaj video u potpunosti moci napraviti to sto zelim. i koji je ovo editor u cemu ovo radis?

[@manuu66966]

respect!

[@axelsotelo8168]

hey can you help me with my code :(