i have a stored procedure which creates a temporary table the table has 5 columns ....since all the 5 columns have a different where clause i have 5 different update statements which update the columns. .the problem is the stored procedure is running extremely slow …..the table holds approx 2000...
Thanks Jim
that was cool ....since i am new to CR i had no idea abt whileprintingrecords and evaluateafter functions
now i know how they work.....
so basically whileprintingrecords exceutes the code below it while printing the record
and evaluateafter will check for the change in the value of...
i want to highlight the first item in the subgroup and then highlight the remaining items alternately. The number of records(items) in the subgroup keep changing. Here is how my group header 1 , group header 2 and detail section look like
H=Highlight
Brand (group header 1)
Subbrand...
I have this statment in my formula
Sales: " + {?Selection1} + "Area: " + {?Selection2}
I want to bold the Text "Sales" and "Area" when it gets displayed in the Report
couldnt find any bold function
Any suggestions??
Thanks
Thanks Terry i worked....since i am new to stored procedures i thought i need to read the number of rows and run the update in loop .....also my try4 was a subquery ...i realized that i cant do the inner join if try4 is subquery so decided to make a memory table out of the subquery..
thanks anyways
i have two tables one is try3 and other try4
Field try3 ->Itemname,Sales,Itemid
in try3 Itemname and itemid colums are are alredy filled and sales for each record is "Zero" ,there are 100 such records
Field try4 ->Sales,Itemid
Each distinct itemid has sales value
i want to assign...
i have two tables one is try3 and other try4
Field try3 ->Itemname,Sales,Itemid
in try3 Itemname and itemid colums are are alredy filled and sales for each record is "Zero" ,there are 100 such records
Field try4 ->Sales,Itemid
Each distinct itemid has sales value
i want to assign...
I am collecting some real time process data from a manufacturing application into Sybase. I have a table in FoxPro whose source the Sybase table. The Sybase table is supplying values ever 2sec to FoxPro. In order to see the latest values in FoxPro I have to close the FoxPro application and...
It works ……
In the class i added the number of LED's i wanted in each of "myled#" so in case of "myled4" there are 4 leds of same color in it.
Mike if I am not bothering can you explain me how the class works.
Thanks a lot
Prakash
Hi Mike
What i was looking for is if the EMP_ID ="2" then there would be 2 led's
if the EMP_ID ="4" then there would be 4 led's
Doesnt matter if the color of all the leds is same.
Hope this is clear if not please let me know
Thanks
Hello,
I have grid, which displays many records during run time. I have a column in the grid that I want to display graphically say in form of LED's or bulbs. LED’s are circular shaped and are placed outside, adjacent to the row of the grid. There are 5 leads for each row. I can change the color...
here is the code that i have in the program that runs the form
CLOSE DATABASES ALL
SET DEFAULT TO C:\project_trial
SET EXCLUSIVE OFF
SET MULTILOCKS ON
OPEN DATABASE 03_24
DO FORM trial
and in form load event i have SET REFRESH
My form was in PrivateDatasession and i wrote the code in Forms "Load" as well as "int" procedure still the data does show up.
The form that i have right now is created thru wizard will that make any differance. i guess not??
HI DSummZZZ,
I have Set Refresh to 10,10 in my code-->program and i am running the form from same program .But still cant see the latest value in Form. Only after i close the form and reopen it i can see the latest value..Any suggestions
thanks
Hello,
My FoxPro table is getting data from another database, that’s Sybase .The Sybase feeds data very 10secs so the FoxPro table gets populated very 10 sec .Is it possible to show the latest data in the form during run time. Say if I have the “Record Source” of a grid as the table that is...
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.