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 Rhinorhino 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: *

  • Users: ExtraD
  • Content: Threads
  • Order by date
  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

    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 =...
  6. 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!!!
  7. 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
  8. 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...
  9. 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!
  10. 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...
  11. 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...
  12. 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, _...
  13. ExtraD

    retrieve data from a outlook public folder

    Hi, I was trying to retrieve the number of active tasks from a public task folder in outlook. With the MAPI I can retrieve the folders data/properties but how can I retrieve the active number of tasks? There is a count property but this gives me the total of tasks. Or is there an easier way...
  14. ExtraD

    stored procedure with output variable

    Hi, i made an stored procedure with output variables. I succeeded to execute a normal procedure but how can I read the return value? This is how I do it: Dim query As String Dim rs As ADODB.Recordset Dim rsFlex As ADODB.Recordset Dim cmd As ADODB.Command Dim param As...
  15. ExtraD

    SCATTER command not public anymore?

    Hi, i made severall programs in foxpro 2.6a and now i'm migrating to foxpro 8. i'm creating a new program in 8 but when i use the scatter op in the load of the form i can't use the m.var in a page (tab control). aren't the m.var's anymore public? or is there another way? thanx
  16. ExtraD

    Printing files with foxpro 8

    Hi, I think its an simple question but i can't find the answer. How do i print a file (no report) from within foxpro with no printer selection screen to the default windows printer. I found some shell examples but then i get the printer selection screen and i just need it to be printed on the...
  17. ExtraD

    Guru, scripting question

    Hi, I have made a new task in an outlook 2003 client that converts incoming emails to a task. When creating the task I copy several items (body, header, from,…) to the task. But one of the things is that when I copy the email body to the task it losses its original format (html) and becomes...
  18. ExtraD

    How to insert a DateTime exact on milliseconds (interbase)

    Hi, i have the following question. how do i insert a datetime millisecond exact in interbase? i know how to insert a normal datetime: CStr(DateTime.Now.ToString("MM-dd-yyyy hh:mm")) but how do i insert one with milliseconds? Many Thanx in advance!!!
  19. ExtraD

    How to use mschart

    Hi, i have been searching the net. but i can't find a good example how to use the mschart component. does somebody has an example? thanx!
  20. ExtraD

    Dynamicly assign menu items to mainmenu

    Hi, again a question :) i know how to retrieve file and directory data. but now i want to transform this into a menu. someting like this: ----------------- Main | word | excel | ----------------- Sub | doc1 | excel1 | | doc2 | excel2 | -------| excel3 | ----------...

Part and Inventory Search

Back
Top