I am developing a small app to do some very minor work with an OPC server. I can connect and subscribe to tags with no problem but can't figure out how to write a value back. There seems to be tons of examples for VB.Net out on the internet but almost none for C#. Using VB.Net is not an option...
Is there a way to change the connection information of the SQL server at runtime so a program can accomodate a different SQL server name but the tables are named the same?
I am beginning to write an app that needs to be able to connect to different server names but access the same database...
I am new to C# and have a question regarding filtering of data. I have created a poject with a single form. In the project I added a Data Source with a data set to a single table in my database.
I then dropped the Details of the data set on my form which gave me textboxes for each column and...
I am new to C# but have programed in VB6 and VFP and have started the process of learning a new language. In going through some tutorials on forms I have noticed something that I am not used to. It seems that when you create two forms and call one from the main program and then call the other...
I am developing an application where I am using CursorAdapters and SQL passthrough for most of the data heavy lifting. I have been told that the data will be moving to a new server so all the conection info will change. With the SQL passthrough it is simple to change the connection info, I have...
I am trying to implement the solution from
Better Date\Datetime Controls
faq184-3913
and am having a little trouble. The problem is that during runtime, the calendar just flashes up and then disappears. In the development environment, it works flawlessly. I'm thinking it is something obvious...
I think I have read almost every post here about SQL Passthrough and cursor adapters and I am still left with questions on the best way to do certain things. I understand that many times the answer will be "it depends" but here are a few questions to help me better understand. First, I use SPT...
I'm trying to manage data in a SQL table using a VFP 9 form and I was planning to use a CursorAdapter to handle the data heavy lifting. I ran into a problem where one of the columns in the SQL table has a data type of REAL and has data that goes out several decimal places. This would be a number...
I am trying to create a rightclick event on the textbox of the first column of a grid. I have the grid already on the form and when the user enters a value in a textbox and presses enter, I use the following code to get the data and then add it to the grid.
If I add the right click event to...
Can the scroll bar on a combobox be tied to the data so when you slide it up and down using your mouse, the items in the box scroll with it in real time?
Ed
Ok, this seems so simple yet the solution escapes me. I need to be able to format a USB drive prior to writing data to it to make sure it is the right file structure. If I use this line in the command prompt, it always asks me to press enter to continue; FORMAT F: /V:VOL /FS:FAT32 /Q
I have...
Can I have forms from one project used in another project? I have two stand alone apps. I'd like to be able to call the forms of one app from the other app. Seems like there would be path issues but I haven't been able to try it out yet. Just thouhgt I'd check to see if anyone has tried this...
I have a table that that has a datetime column and I want to select all records that are of a specific date regardless of the time.
When I try this code in query analyzer I get no records returned:
SELECT *
FROM TCData
WHERE TCData.dClockTime = '06/16/2006'
I suspect it is because without...
I guess I just do not understanding the posts and FAQ's in regard to the multiple detail bands in a report. If someone could dumb it down for me I'd really appreciate it. Here is what I'm trying to do;
I'm trying to create a report that has a paernt table and 2 child tables. There is only one...
I have a txt file that is a fixed width with no delimiter and am trying to dump into a SQL table. The problem is, as the subject suggests, the date field. Here are a couple of lines of the txt file and the field lengths are:
6, 8, 6, 4, 4, 20
4300312/16/05 036032.3 UPSCUPS COLLECT ******...
I have a situation where I export data from a legacy database to a comma delimited file using " to designate text and this cannot be changed. I am then importing them into a tables for further use. There is one text file that has a situation where the characters ,", show up and it blows up the...
This seems harder than I think it should be but I can't seem to work through this easily. I have a VFP table that has the identical structure as a SQL table except for a time stamp and identity column. I would like to insert records from the VFP table to the SQL table. How would I start? I was...
I have the following code that I am trying to use to print part labels based on the quantity in the qty field. The code only does the first matching record and then stops. If I remove the FOR..ENDFOR loop the code will cycle through all matching records. I tried using LOOP with no luck. What am...
Is there a way to print multiple copies of a report without having to loop the REPORT FORM command? I would like to have the user define the number of copies from a form entry and then print that many copies passing the qty along.
Any help is appreciated,
Ed
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.