Topic: [Solved] Delete Col and value
Hello Dmitry and all MVD fans,
Wether by script or with SQLQuery button, we have the ability to hide one or more columns issued from the query by using the reserved word 'delete_col'.
When delete_col is used on the ID of the record, the tablegrid does not display the ID in the row, but
Form1.tablegrid.dbItemID
still refers to the ID and can be used for another query or function.
My question :
If on a SQLQuery Button I have this query :
SELECT
artist.id,
artist.artist_name,
artist_asset.auto
FROM
artist_asset
INNER JOIN artist ON artist_asset.id_artist = artist.id
WHERE artist_asset.id_asset = {edAID}
ORDER BY upper(artist_name) ASC
and this setting for the column names in the Tablegrid :
delete_col,Artist Name,delete_col
how can I still get the value of the "auto" field in the tablegrid (on cell click for example...) ?
Thanks in advance
Mathias
Each time I get a divorce, I keep the house
Zaza Gabor