Recent content by beltijs

Hi! i not understand if i can't get it right or if just is not possible. I have a Ttoolbutton in a Ttoolbar, Ttoolbutton->style = tsButton, Ttoolbutton->caption = &New Ttoolbar->showcaption = false. So, according to the definition if i press Alt+N the Onclick...

Hi! I have this situation. Mysqlquery | datasetprovider | clientdataset | datasource and a dbgrid (grid_A) showing what's in the clientdataset. The query returns a set of records, but in the dbgrid there is 1 record that is not shown. the strange thing is that trying to...

Works perfectly, THANKS A LOT!!!!

I'm using mysql 4.0.21 and Toad to run this query. The message i'm receiving is that there is a Syntax error, where? select a.id_opcion, a.nombre, a.campo, a.visible, b.id_usuario, if(b.ancho is null, 50, b.ancho) as ancho, b.posicion from det_rmen as a left join...

I couldn't make it work, i was reading a lot of posts in some forums, and i found out i have to use tupdatesql to execute diferents action over the data returned by the sql. But it didn't work. Otherwise i realise that de performance was very poor. So i decide to use a msqldac component. I...

ok, im having this problem: Database = mysql Tables = ttable connection = tdatabase dbgrid with Tquery i want to update, i have done this with ado tables and querys. Ok, query says: " Select a.id_movimiento, a.id_item, a.id_tamanio, c.descripcion as desc_tamanio, a.id_deposito, a.cantidad_ped...

hi! I want to you to help me with some choices i have to make. I have an application that the user install in their computer (i say these because i want to consider that every user may have a diferent computer with diferent resource and programs installed), i first work with dbf tables, but i'm...

i think i have to create user C in A and B, because there is one folder in each machine that is shared for everyone (including C), and other folder in A that is only shared with B.

hi! i've this problem. A network with 3(A,B,C) machines, 2 of them (A,B) wants to share a folder without sharing with the third one (C). Ok, i've read a lot of posted maded to this forum, but i found a problem that i can't solve. I create in all three machines all users account of the network...

i solve the problem in this way: i have modified de sql statement that select the data like this: SELECT nro_maquina, ubicacion_nombre, cliente.nombre, ficha_tec_e.id_cliente FROM ficha_tec_e INNER JOIN cliente on ficha_tec_e.id_cliente = cliente.id_cliente...

it's a Tadoquery with this sql: SELECT ficha_tec_e.nro_maquina, ficha_tec_e.id_cliente, ficha_tec_e.ubicacion_nombre FROM ficha_tec_e; Because of this problem i have take away all relationship with other tables until i solve this problem. I have take away all indexes, none of the fields are...

Hi! I having some problems with a ClientDataset with a Datasetprovider. When i make clientdataset.applyupdates(-1) it shows an error message: 'Syntax error un sqlstatement'. The database is Ado, the datasetprovider has his updatemode set un UpWhereKeyOnly, and the key fields are specified. I...

hi! I've this code for a clientdataset myclientdataset.first while not myclientdataset.eof do begin if myclientdataset.UpdateStatus = usInserted then {do something} if myclientdataset.UpdateStatus = usModified then {do something} if myclientdataset.UpdateStatus =...

Hi! How can i change the language of the buttons in the dialogs screens?. I want to translate it to spanish instead of "Yes" and "Cancel" i want to have "Si" and "Cancelar". Thanks

Hi! i have a Tadotable, i have set the indexname with an index i define in the database for that table. When i open the table it doesn't order the records acording to the indexname i'have define. When i add a Watch for the indexname of the table in the line i open it, the indexname have the...