Search results for query: *

Using Reportnet I have 2 dates: date1 date2 on each row I want another field to tell me the difference in minutes between the two. When you create a calculated field, you have 3 options, the documentation tells you to use the 3rd option (Layout) to use runtime info. (I have tried all 3...

I have two tables tblallclaims tblpaidclaims they both have this field: age decimal 9 I have a lookup table tbl_ageranges and an alias of this lookup table alias_tbl_ageranges this table&view have fields - exactage decimal 9 tblallclaims will link to tbl_ageranges on the exactage field...

Trying to recreate an Impromptu report in ReportNet. I have a very simple grouped report: Priority # Completed 1 201 2 100 3 103 ... and so on. There is another field being used in the query called Completed that is a date/time field. I am...

Hi all, Making a crud matrix in I guess the "traditional" format. So I need to determine what Foxpro keywords match up with the CREATE READ UPDATE DELETE All I'm aware of as far as access to tables is NOUPDATE and SHARED and EXCLUSIVE. How do those translate? EXCLUSIVE C,R,U,D SHARED...

HI All, I have a "best practices" question, looking for not necessarily code, but english on "how to" do the following... ( a little explanation first) I have a big production table that I hit on a nitely basis to perform calculations and a variety of things. I am using a subset of this table...

Hi all, I've got an application where some of the criterion in the queries are hard coded and I am trying to remove all of that hard coding and use tables to make the app dynamic for the user. My question is one of design. I am looking for ideas as to how to design the tables in a way that I...

is that possible? Here's why... the two values don't always 'add down' so to speak, let's say I have 60000 for my beginning balance and 70000 for my ending balance. When you go down through all the other adds and subtractions, there are too many to get into all of them here, the ending...

Hi all. I have a cube that produces some pretty cool reports, however they are 'web' based and the results when exporting them to pdf's or xls files really isn't what the user wants. They previously had a nice pretty foxpro report that all they needed to do was click a button. Now, with...

Does Sun have their own UNIX based OS?

hi all, brand new to cognos, beginner question here... can't find it in the search tab i've got a report, list report, which is the standard columns/rows and I have changed the grid lines to be a lighter gray so they are not so tough to look at, but, it appears that because each cell is...

Hi all, I have this in the fox section, too, didn't know if anyone here could help... RUN DTSRun /S "DWPROCESS" /N "SiteCount_1_LoadTextFiles" /G "{00B299BE-E99A-4CA2-AC5D-2254B3D5F0DB}" /W "-1" /U dts_test /P test there is a param here that foxpro doesn't like we tried it like that... and...

I have the awful task of rewriting code to use cursors instead of tables, now I know I can SELECT blah into cursor readwrite to allow for updates and multiple indexes, but can I do the same using create cursor? From what I see in the docs I would say no, but sometimes the right info isn't in...

hi all i've read a bunch of posts on querying sql tables and returning info, but I just want to update the SQL tables and that is all. I don't need to check anything or bring anything down from SQL, I simply have a table that I create in fox and I have an identical table in SQL that I want to...

Does only the first line of a CATCH block get executed? Is there an instance where this happens?

When I issue this: DIR myPath I get all the attributes of each file, datetime, size, etc... but when i issue this: dir *.ZIP I only get the filename. I am looking in the MSDN and am following that, I don't see anywhere that it says that it only returns the name if you issue a specific...

this is the only information i have is "Jan 10" in a string. I am trying to figure if that date is within 2 months of now. what I really have here is some files on a unix server that I cannot find a datetime stamp on, this is all i see... if you know of another way, i'm all ears

i turned this on but i can't seem to figure out where the log is.... can anyone help me here?

Is there one? I'm trying to ftp a 7 gig file from NT to Unix and it seems to bomb at about 2 gigs. Is this a limitation? Is there a setting anywhere that I can change to get this whole file? Thanks

After getting one of those lovely fatal exception c0000005 errors, I got a series of error reports and sent them each time I got the message. Then, VFP 8.0 is closed automatically. I am now not able to even open VFP 8.0. I can open vfp6.0 and can run apps that are in 6 and/or 8 just fine, I...

I am not sure if this is even valid, can someone tell me? If it isn't, is there a similar way of accomplishing this? replace intbills.prevproc WITH .t. ; FOR adddate = DATE() ; while claimno IN (select claimno FROM csrOld) Can I do a lookup like that within a REPLACE statement? I get the...