Search results for query: *

Can someone tell me how do I delete some rows effectively on a daily basis and update it with new rows from a temporary sql table. I have a huge table of 120 Mil rows(actualtable). and I need to update it with 1mil rows(temptable) everyday. I usually do this but it takes awful lot of time and...

Can any one help with some database issues. I have to deal with huge tables like tableA (70 mil rows )and TableB(45 mil rows.) and they grow on timely basis. Every month I have to insert from TableB into Table A with some calculations. On an avg. a month's data is around 5 Mil. The way Im doing...

How can I display a message to user saying "there are no are no records at this time" when there are 0 Records from the table, something like following statement? IF RECORDCOUNT EQ 0 THEN TYPE "No records at this time"; Thanks -P

Can some one help me with the below If statement, I dont know where I'm going wrong, it looks simple but, wont work. DEFINE FILE MYFILE TEMP/D12.2=IF FIELD1='A' AND FIELD2='B' AND FIELD3='ASD' THEN MYFIELD ELSE 0; END TABLE FILE MYFILE PRINT TEMP END gives me below error message 0 ERROR AT OR...

can anyone tell me how to verify if table exists before I issue DROP TABLE JOBS for the following statement SET SQLENGINE=SQLMSS SQL SQLMSS SET SERVER CONN1 SET COMMIT = ON SQL SQLMSS BEGIN TRANSACTION DROP TABLE JOBS COMMIT WORK ; END by the way, im getting this error message when I try...

Can anyone help me with IFrames. Im using an IFrame having a SRC for another page(html with some javascripts inside) on another server. I couldn't find out the resolution for that problem on the web. It gives me an "Access Denied" message. I know its got to do something with security but i dont...

I am getting a warning message on the browser when i run a html file(http://mywebserver/approot/cmisreports/file.htm) after i publish any FEX Procedure. Im using WF436 and the message is: Your connection to server has been lost, please reconnect. The URL where the page stops is...

Can anyone tell me if there is any easy process to move my apps from 4.3.6 to 5.2.3? I tried to copy and paste it never worked though -P

how do i display a field after a join from specific table. JOIN EUSER.EUSERNAME IN eUser TO ALL EATTRIBU.EUSERNAME IN eAttribute AS JOIN0 SET ALL =ON TABLE FILE EUSER i wanna print the join fields from both the tables euser.eusername eattribute.eusername? END

How do i specify the left or right outer joins in wf?

how can I print the time field (value=3/24/2003 11:44:00 AM) exactly as in SQL database. when i tried to print it prints only 3/24/2003 but not the whole time stamp. In other words I need to print full time stamp. I tried to change the attribute in the masterfile from YYMD to HYYMDS but, it did...

Can i print stuff based on some if condition like TABLE FILE MYFILE PRINT MYFIELD1 OVER MYFIELD2 OVER .. .. IF FIELD2='something' THEN PRINT SOMEFIELD AS 'SOMEOTHERFIELD' END any help would be great. THX -P

is there anyway to concatenate a line break or new line in define statement Like the code below DEFINE FILE MYFILE TEST=FIELD1 | FIELD2 | 'linebreak or newline' |FIELD3| FIELD4 END Appreciate any help -P

Can anyone tell me how to concatenate more than 1 field and displaying it as a single field, in other words cramming or sqeezing data into one field. I have fields called LASTNAME, FIRSTNAME ,STREET, CITY, STATE, ZIP and some company info in my master file. I want to create a report like...

Can anyone tell me whats wrong with my server. I cannot run any report from my apps. It works on other server. The error message is not specific enough. im using Webfocus432 and server is up and running. http://myserver/cgi-bin/ibi_cgi/ibiweb.exe Warning Your connection to server has been...

Hi everyone, I have a date format problem. I need to format year in the following manner everything seems to be fine except setting YEAR=YEAR+1 YEAR/A4YY='&USEYEAR'; concatenating here for querying TESTDT1/A8YYMD=YEAR | '0701'; BEGDATE/YYMD=TESTDT1; ...my query have to add reset value of year...

Can anyone tell me how to play with dates. I need to be able to manipulate the user input frm YY format to YYMMDD to be date and month specific reports. In a nutshell, user will provide me an year and I need to be able to generate reports based on that year Eg., for the year 1900, I need to...

Can anyone help me with creating an annual report. I have now quarterly reports based on some set of dates it gives me number of records affected for some where clause. DEFINE FILE MYFILE BEGinDATE/YYMD DFC 20 YRT 00='&Begin_date'; ENDDATE/YYMD DFC 20 YRT 00='&End_date'; KOUNT1/D12=IF...

Can anyone tell me how to change the view of my report from field1 field2 field3 field4 value1 value2 value3 value4 to something like this field1 value1 field2 value2 field3 value3 field4 value4 I know it sounds stupid but, im fairly new to webfocus. My fex is as follows, all my fields are...

Can one tell me how can we move an ASP.NET webapp to another server or another location. I tried copy& paste and copy project but nothing works. Sometimes, I feel ASP was good cos' the whole source code was portable anywhere with IIS. Please help