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...
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
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...
hello
i have a grid that is populated from tables.
At start i have the readonly property to true and allowcelselection to false and i have a checkbox on the form to check it and make the grid editable. (readonly = f and allowcellselection .t.)
but this makes all columns editable even if i have...
Thank you Mike and Olaf.
Very informative.
But i have to search more because my "tableA" goes to top after the sql query.
And worse, it does not do that in all cases. sometimes it stays at the current record.
haha, yes
because i try to understand why it goes to Top on table-A
even when i store recno() in a variable and issue goto varW at the end of the select statement
sometimes it goes TOP
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.