Recent content by Akourou

actually Criss solution worked fine and I omitted some columns as they are not needed BoundColumn = 2 ColumnCount = 2 ColumnWidths = "231,0" RowSourceType = 6 RowSource = "guest.lastname-(', '+guest.firstname), employeeid" BoundTo = .T. ColumnLines = .f. thank you all for the info

hello, I have a combobox that is used to select a guest from a table of guests some of the properties of the combo: boundcolumn=.3 boundto=.t. rowsource = guest.last, first, g_no rowsourcetype = 6 fields the combo works fine my problem is that when i select from the dropdown list then in the...

thank you Chris and Mike

hello, Is there a method like setall to set all rightclick method of all textboxes of a form? for example i want to set all rightclick of all textboxes to copy the value to the clipboard thank you

I will agree with Chris that the modal mode is not very convenient. I would need to switch to modeless mode once the save button is clicked. I will describe a bit more my concern / problem. This is the way I work with forms for editing dbf data and correct me if it seems wrong or...

hello to all I want to always keep focus on a form when I am editing fields on it. Not to be able to click anywhere outside of the form unless I save my changes. is that possible? thank you

thank you Chris very optimized approach

thank you all for the solutions. it worked fine. I do the formatting during the select query because I present this info in a grid afterwards.

hello i have the following select statement: SELECT bdate, platforma.descr, CDOW(checkin)+" "+DMY(checkin), ALLTRIM(STRTRAN(strtran(booking.notes,CHR(13)," "),CHR(10)," ")), guest FROM booking ....... I noticed that when the field contains an expression like...

thank you Tamar, your article about crosstab is very informative and solves many of my issues. The only problem is that the link for Alexander Golovlev fastxTab is no longer available. Do you know if there is another link to that download? thank you Andreas

thank you Tamar, this select statement is very clear. is it possible to include more analysis in the same statement? for example the above statement calculates total nights per house. can i have more sum() in the same statement to analyze these total nights according to platform type? for...

hello to all! I hope you're getting on ok in the current crazy situation. my question: i have a select statement that collects data from several tables into a cursor. SELECT bdate, platforma.descr, house.h_name, guest.descr, CDOW(checkin)+" "+DMY(checkin), nights...

Mike, thank you. that was it! i had forgotten tables in the data environment of the form. I deleted these entries and now it works as it should. thank you Mike and Olaf

what i want to achieve is the record pointer in booking table not to move each time i open the guest form. Mike, i do not know what you mean by private data sessions but i do not open any tables from my forms. I have a procedure that run at the start of my application that opens all tables, and...

It is true, the grid has nothing to do with it. I deleted the grid and still i have the following behavior: I have guestform that uses guest table to manipulate guest info. I have bookform that uses booking table to manipulate bookings of guests. Bookform has a combobox bound to the guest...