Search results for query: *

Hi, A time ago we migrated from Foxpro 2.6 to 8. With this migration we saw that the SCATTER VAR wasn’t “public” anymore. With the migration we miss used the READ to continue the “public” effect of the m. VAR’s. But now we are planning to migrate to SQL Server, with this migration I also would...

...DECLARE @Env AS VARCHAR(50) OPEN cEnv FETCH NEXT FROM cEnv INTO @Env SELECT @Env = RTRIM(@Env) -- Build sql query SET @sql = 'SELECT fc.*, ft.*, ts.tr_currency' + ' FROM Order07' + @Env + '.dbo.FleetCost fc, Order07' + @Env + '.dbo.FleetCostType ft, Unitstat' + @Env + '.dbo.Transporter ts'...

Hi, I use the net send option within the operators list. Now the only one who can change this is the sql admin. Is there a way to do this via a script? Is this stored in a database? Thanx,

Hi, I have the following question: I created a class called “unit” within this class I have a member called “type” from the type Public Type FCCUnitType a As Double Bus As Double BusH As Double B As Double c As Double d As Double f As Double End Type Now when I do...

thanx JoeAtWork thats the solution!!!

ok this changed. stil the same problem :(

Hi, I’m trying to use a class that’s created in an ocx. For the post I created a small sample project which is as following: A ocx project called: Project1 class module called: Class1 Option Explicit Private mStategroup As String Public Property Get Stategroup() As String Stategroup =...

Hi, I’m looking for an option to see which users have a specific file open. Eg file.exe is open by user1, user2, user3 It’s the same as you have windows 2003 server – computer management – open files – accessed by. I would like to do the same but then in foxpro. Any solutions? Thanx!!!

thanx for the quick response

Hi, i created a DTS on one server now i would like to run this also on another server. the DTS is saved as a *.BAS but i cant find an option to import this again. is there an option? if so could you please help me. thanx

Hi, i found a piece of code on the internet and it seems to work ok accept its needs an SMTP service installed on the machine. now i saw some comments that you could also use a SMTP thats running on a server. but how can i address this server? this is the code i'm using: Local...

Hi Mike, "this needs an SMTP SERVICE on a server, not on every client" how can i then call the SMTP service from a server in the client app? could you please change this in my example!? thanx

Hi, creating attachment is an option. i tryed the following 2 solutions but both couldn't be implemented because of the software requerments. Local lcFileName,lcStr && Variables locales Declare Integer ShellExecute In "Shell32.dll" ; INTEGER HWnd, ; STRING lpVerb, ; STRING lpFile, ; STRING...

Hi, I think I didn’t give you the complete background info, here it is. I’m sending self created html emails. But some customers don’t support html/text they have it set to plain text. Therefore my emails are converted an all style sheet/html settings are gone. Which doesn’t have a great affect...

Hi, I created a html viewer using the activeX control and shell.explorer. now I was wondering is there a possibility to export the html page to an image (gif, jpeg)? Or do you know another way to convert html pages to an image. Many thanx!

hi, i have the following question. i want to net send a message when somethings wrong with a job. i found the option net send [operators->net send]. but is there also a possibility to send e message to a group? this message needs to be send to 15 people and to do this at user level i think is...

Thats correct i'm experimenting to get decimals in it. but i was to fast i think. i found the option NumericScale and Precision. thanks for the quick response!

Hi, I found this code to create disconected recordsets. But how can i use a decimal value. Because he creates always a Long type of field. Set oRS = New ADODB.Recordset oRS.CursorLocation = adUseClient oRS.CursorType = adStatic oRS.LockType = adLockBatchOptimistic 'Add a few fields With...

Thanx for your replys i will go for the nothing option.

Hi, I have a function header like this: Private Function CostCalculation_calculateCosts(cnSQLFY As ADODB.Connection, _ cnFoxpro As ADODB.Connection, _ cnSQLFCC As ADODB.Connection, _...