Search results for query: *

My VFP application connects to my Amateur Radio Transceiver (via Serial COM Port 3) for CAT Control. CAT Control is a generic term used to describe how a PC can control the frequency and various other settings of a transceiver. The CAT commands are bi-directional. My application has run for a...

My application reads the Frequency of my Transceiver via a serial port. The format of the Frequency for example is “FA007074000” or “FA144174000” I would like to strip the “FA” plus any leading Zeros (1 or 2 in my case) to produce a Frequency Reading of “7074000” and “144174000”. Actually I’ll...

Looking for some ideas on how to provide a "Splash Screen" for my application(s) whilst it's initialising. Nothing too fussy, just a message showing that the program is running. My main form Logbook.SCX is currently a 'Modeless', 'Top Level Form'. * * Display Main Form *...

I have a TEXTBOX where the 1st four characters need to be in the following format:- 'Uppercase Letter' + 'Number' + 'Number' + '-' followed by any number of characters i.e S93-Wexford I have tried setting INPUTMASK to !99X which works for the 1st four characters but how do I allow for any...

Over the years I’ve been developing an application for my Amateur Radio activities. The project, although it meets my current requirements has become rather cumbersome with code placed here there and everywhere. As my thoughts keep returning to OOP, should I / shouldn’t I. I thought I'd take...

I have been looking at the following thread by ‘Steve-vfp9user’ [link ]https://www.tek-tips.com/viewthread.cfm?qid=1813317[/url] oOutlook = Createobject('Outlook.Application') oNameSpace = oOutlook.getnamespace('MAPI') oOutbox = oNameSpace.GetDefaultFolder(4) oItems = oOutbox.Items oMailItem...

I would like to add a Column to Cursor 'curLogbook'. I currently populate 'curLogbook' using: SQLEXEC(SQLCONN,lcFields_List,'curLogbook') I would like to add a "ALt_Col" Field and tried using the following code: X = "Alt_Col Num(6)" ALTER TABLE curLogbook ADD COLUMN &x which resulted in...

In my application I have a Pageframe that contains a grid. In the Activate of the 'Page' I have some code that runs a 'check up' routine. Whilst this code is executing the 'Page' is waiting for the code to complete before it shows the form in full. You can still see parts of the previous screen...

I am trying to update a MySQL Table from changes made in a VFP Cursor. The following code updates the field "Call_160" in Cursor "curLarge_Squares" with "Test". SQLEXEC(SQLCONN,'SELECT * FROM &TBL_WAB_Large_sq ','curLarge_Squares') INDEX on LG_SQUARE TAG lg_square...

I would like to use REPLACE (TEXT...ENDTEXT) to update a Cursor. I have about 30 Fields to Update, this is a shortened version for test purposes. Select curLogbook TEXT TO lcSQLUpdate TEXTMERGE NOSHOW Replace COL_Band with UPD_Band, COL_Call with UPD_Callsign, COL_CNTY with UPD_CNTY...

I have the following code in my application which works as required. Is there a way of COUNTing into my Dimension ARRAY wagi(10) instead of first storing it in wagi_count and then storing it into my Dimension ARRAY wagi(10) ? PUBLIC ARRAY wagi(10) SELECT COUNT(*) FROM csrWAGI_wkd where...

Hi, I have the following 10 x 10 Grid on a Form that I drew with Lines & Shapes and each Square has code that executes when "Clicked". I remember it being a long tedious job! I would like to be able to code it using OOP but lack the knowledge. How would I make a start? Regards, David...

My Form displays a "Container" with Textboxes for inputting data. I would like to have a selection of Containers offering a variation of Textboxes but only displaying one Container at a time. I'm thinking along the lines of using a "Spinner" to scroll through the various Container options and...

Further to discussions on another thread: - https://www.tek-tips.com/viewthread.cfm?qid=1805853 I thought it would be beneficial to start a new thread. As a recreational Developer / User of VFP, any applications I may write are for my own personal use. My main Hobbies are Amateur Radio and...

My application interrogates a WEB Based Database and returns e.g. <fname> David </fname> The following code has been working ok until recently I can across a <fname> . </fname>. XMLToCursor(QRZ_Lookup,"cur_QRZ_Lookup") Contacts_name = StrExtract(qrz_lookup,"<fname>","</fname>") + " " +...

I have MySQL 8.0.21 Server Set Up and working on my Windows 10 PC. I would like to be able to use Upper Case Database Names when using phpMyAdmin. The Program runs ok when lower_case_table_names=1 but gives the following error when lower_case_table_names=2 2020-07-15T06:50:41.118617Z 1 [ERROR]...

I receive an Email containing Data to update a Database. The format of the Email is: Date Number Callsign Area Notes 01/01/2020 52931 M9TEK SP83 05/01/2020 52932 GW9TIP TL14 Any additional information here Although the Date and Number Fields are...

As a Recreational User of VFP I dip into / out of VFP periodically; maybe not too dissimilar to a Programmer visiting different clients. One of the issues I have with my aged memory is finding my around my code, remembering where pieces of code are located, List of Procedures, Methods and...

In my application I'd like to constantly update and display the "Current Time" in a Text Box called "Start Time". When data is entered in another Text Box and this Text Box Loses Focus I'd like the "Start Time" to stop updating. Is this possible? Regards, David. Recreational user of VFP.

In the following code.. SQLExec(WABCONN,'SELECT * FROM &TBL_WAB_Books WHERE callsign LIKE ?CALL_TO_SEARCH and admininfo NOT LIKE "(NLV-R)" ORDER BY B_Number','cur_book_search') BROWSE Font 'Verdana',12 NOEDIT if used('cur_book_search') USE IN cur_book_search && Close Cursor MESSAGEBOX...