Search results for query: *

Hello Everyone. This is likely the wrong forum to post this. If there is a better one I will happily move my discussion there. I'm currently looking for a way to record (possibly as simply as storing data in excel, data on files uploaded via SFTP. I have a server with various users, but I'd...

Please pardon my newbie-ness to this thread. I've had to figure out on my own how to create a test environment for a spark server my company is using to handle data. I've jumped through various forums and have had to intall python itself using scoop via powershell, and set up PyCharm, spark...

I'm not terribly great with access, so I don't know if I'm even starting this off correctly. Here is the relationship of the tables: What I'm wanting to to is create a form that will update the "PropertyPieces" table with the id from Property and id from Pieces. The pieces table contains a...

I'm attempting to create some conditional formatting for the example screen below: What I'd like to see is if I accidentally enter duplicate criteria marks (with any value) in any of the cross cells for a particular "Group" B-F will highlight with a color. I was able to create something...

I'm having some issues with some VBA code. I've got a checkbox list and a button at the bottom that hides all of the rows/checkboxes that are not selected. The problem is that when I hit the box to view all again, the checkboxes are then all piled on top of each other rather than where they...

So I'm trying to pull data from a few tables which require a max function to pull the proper information out. The query I have works wonderfully except that there is a certain set of records it's not returning. Those records would be ones that are actually in the ProspectDeleteBlock table, but...

So I'm attempting to create a class to use, but I want to create it straight in code rather than using the VFP Visual tools in VFP 6. I am not making a visual application. Is there a way to do this? I've attempted to create my class inside a prg, and to start I went with Ye Olde "Hello, World!"...

Let's say I've got a table, and I want to pull a count of a specific value for one specific field... like anyone who lives in CA, and then save that as a variable for later use, how would I accomplish this? I've been told I could do an actual query, then save the results as a separate table...

This is probably a pretty noob like question, but I have a field with numbers that need to be zero filled to be exactly 10 digits... any ideas? Thanks! -Doug

Hello All, Using VFP 6.0, trying to iterate through some .dbf field names that have #'s at the end (ex: field1, field2). Is there any way to do this without having to list out each field individually? My Code currently looks like this: mlybi = 1 DO WHILE mlybi <= 10 IF (('gdate' +...

I'm trying to use an intersect query with foxpro, but I'm getting a syntax error, so I'm guessing foxpro doesn't like intersects. Does anyone know a better way to accomplish what I'm trying to do below? set defa to d:\supporte\loader\00dataanalysis\vfptest mStanConn = SQLCONNECT('server'...

I have a telnet client that was created with java, but if colors are sent with the text, (It's mainly used as a MUD client) it will not process them. Is there any easy way to handle this? I have a bit of java coding experience, but not enough to handle that sort of thing.. If I knew what I was...