Search results for query: *

Thanks for your the replays, I previewed this :(, no chance. you are right JamesLean i want to update these fields every time a row is modified. Vito M. from BARI (Italy) --------------------------------------- When you build a TEAM, try always those that they love to win. If you do not...

s it possible to make a stored procedure trigger that work for all tables sorry for the mistake Vito M. from BARI (Italy) --------------------------------------- When you build a TEAM, try always those that they love to win. If you do not succeed to find them, then try those that they hate to...

Hi all, is it possible to make a stored procedure taht work for all tables ? what i need is to set values for two fields (usermod, datemod) that i have in all tables in my database, with the current database user an current datetime values. Thanks in advance. Regards.

Thanks for the reply, The problem is that i want to display the average in the chart in the format hh:mm:ss. PS. sorry for my bad english. Regards Vito M. from BARI (Italy) --------------------------------------- When you build a TEAM, try always those that they love to win. If you do not...

Hi friends :D i have trouble in summary functions a date time display. The case is the following: i need to compute time difference between the begging and end of a task and show this difference as hh:mm:ss, i need average of this difference and plus i want to display this difference in a a...

GRANDEEEEE :D This works ;) ... a star for you Tanks again. Vito M. from BARI (Italy) --------------------------------------- When you build a TEAM, try always those that they love to win. If you do not succeed to find them, then try those that they hate to lose. Ross Perot

Hi lbass, thanks for your solution, works fine except for the case where DateDiff is used over two records. ---------- @cicleDiff DateDiff("s", {trv.hbegin}, next({trv.hbegin})) --------- @cicleAvg WhilePrintingRecords; NumberVar SecondsDiff := average({@cicleDiff},{table.groupfield})...

Hi experts, i have this formula on a detail row WhilePrintingRecords; NumberVar SecondsDiff := DateDiff("s", {trv.hbegin}, {trv.hend} ); NumberVar Hours; NumberVar Mins; NumberVar Secs; SecondsDiff := IIF (SecondsDiff > 0, SecondsDiff, 0 ); Hours := truncate(secondsdiff/3600); Mins :=...

I have the same problem, any suggestion ? Vito M. from BARI (Italy) --------------------------------------- When you build a TEAM, try always those that they love to win. If you do not succeed to find them, then try those that they hate to lose. Ross Perot

@rick I need to protect the application, from being copied. Vito M. from BARI (Italy) --------------------------------------- When you build a TEAM, try always those that they love to win. If you do not succeed to find them, then try those that they hate to lose. Ross Perot

Does any one can help me in finding a copy protection routine for VFP applications that i can use for free ? Vito M. from BARI (Italy) --------------------------------------- When you build a TEAM, try always those that they love to win. If you do not succeed to find them, then try those...

I have made many reports using a VFP datasource via a file DSN that's works fine trought my crystalreport viewer application , now i have a request to use these report via del webcomponent server, but i receive the following error: CRAXDRT Error occured on server -2147189176 : Logon Failed...

I have made many reports using a VFP datasource via a file DSN that's works fine trought my crystalreport viewer application , now i have a request to use these report via del webcomponent server, but i receive the following error: CRAXDRT Error occured on server -2147189176 : Logon Failed...

I'm developping an application for a warehouse of apparel store and they have some items that are sold in 24 sizes and the request is to show the warehouse in this format: item description price t.qt s01 s02 s03 ...... s24 0001 skirt 10.1 10 1 1 2 ...... 2 0002 dress...

Thanks Mike, yes you are right, but the problem is that i have up to 24 columns in the grid, and is impossible to fit all in a form. I have tried using a second grid at the bottom of the first one but the problem is to sync the two grids, do you have any other suggestion ? Thanks again...

Hi dear friends, is it possible to have a fixed row at the bottom of the grid object ? I want to have a row at the bottom of the grid with the total of columns value. Thanks in advance. Ciao Vito M. from BARI (Italy) --------------------------------------- When you build a TEAM, try always...

Thanks for the help, but not completely works. The first gird is for detail and the second gird displays only one line with the total of the columns in the first one. Note that the first gird is freezed at column 4. eg. gird1 art. cod. qt price i1 i2 ... i24 --------------------------------...

Hello, does anyone knows how two sync two girds ? I have a form with two girds that not fit horizontally on the form and i need to scoll left and right the second gird when the user scrolls the first. Using the DoScroll metod and Scrolled event works only if the user uses the scrollbar but not...

Yes, that works. Thanks Vito M. from BARI (Italy) --------------------------------------- When you build a TEAM, try always those that they love to win. If you do not succeed to find them, then try those that they hate to lose. Ross Perot

Hello, how is possible to resize a form when the toplevel window resizes. My case is this: i have a top level window in the top level window i have a button the click event contains DO FORM newForm when i resize the toplevel window i will resize the newForm also. Thanks in advance. Vito...