Recent content by ipazzo

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...