Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ExtraD

    how to use the addproperty function correct

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

    stored procedure which returns a recordset

    hi, i have the follwoing issue. i created a stored procedure which returns a recordset: CREATE PROCEDURE [dbo].[prc_getFleetCostData2] @pCostID AS VARCHAR(100) , @pLocatNr AS INT , @pLocatTb AS VARCHAR(10) , @pDate AS VARCHAR(10) , @pAutoInc AS INT , @pUnitType AS VARCHAR(4) AS...
  3. ExtraD

    Set Operator settings via a script

    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,
  4. ExtraD

    Perform something like "macro substitution" in a class

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

    error when trying to use a class in a .ocx

    thanx JoeAtWork thats the solution!!!
  6. ExtraD

    error when trying to use a class in a .ocx

    ok this changed. stil the same problem :(
  7. ExtraD

    error when trying to use a class in a .ocx

    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 =...
  8. ExtraD

    check which user has a file open

    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!!!
  9. ExtraD

    importing a saved DTS as BAS file

    thanx for the quick response
  10. ExtraD

    importing a saved DTS as BAS file

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

    send email through ShellExecute

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

    convert html to image

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

    convert html to image

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

    convert html to image

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

    convert html to image

    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!
  16. ExtraD

    operator net send

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

    fabricated Recordsets

    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!
  18. ExtraD

    fabricated Recordsets

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

    how to check if an optional var exist in a function

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

    how to check if an optional var exist in a function

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

Part and Inventory Search

Back
Top