|
Hi,
I have created a report using TTX file. If i preview the report the sample data in TTX file is not displayed. Instead it shows '1' as default value for the number fields and 'string sample value' for string fields. Please help to solve this.
Thanks,
Ramesh.
|
|
|
|
|
What is a TTX file ?
Christian Graus - C++ MVP
|
|
|
|
|
Tab separated Text file. It is a data definition file used to pass ADO recordset to cryatal report 6.
|
|
|
|
|
Hi
I want to use INPUT, GET etc functions of BASIC to be implemented in VB6 to get the input and PRINT the output but all without using any interfaces like form,inputbox,msgbox ....... i.e. im tryiong tom write a console application in VB6
Is there any way to do that
bye
pitchu
|
|
|
|
|
VB6 doesn't have any built in methods to make a console application. You have to call into the Win32 API to create and manage a console window, along with outputting any text to it and getting input from it.
A simple Google for "vb6 console application" reveals these[^]...
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
i have a serious problem with my loop. My loop can only read the 1st data in my database even though there is 2 data inside. I think the problem should lays on my loop. Can u guys take a look at my loop and try to help me troubleshoot. Thanks a lot cos tis is urgent i got to pass up my proj soon.
While TReader.Read And TReader2.Read And TReader3.Read And TReader4.Read
strActionName = dTable.Rows(0)("ActionName")
strStatus = dTable2.Rows(0)("Status")
strFrequency = dTable3.Rows(0)("Frequency")
strActionDone = dTable4.Rows(0)("ActionDone")
strOneLine = ("ActionName = " + strActionName + "," + " Task = " + strActionDone + "," + " Frequency = " + strFrequency + "," + " Current Status = " + strStatus + "")
MessageBox.Show(strOneLine)
End While
|
|
|
|
|
This is a disaster - why do you have four readers ?
Christian Graus - C++ MVP
|
|
|
|
|
i use 4 reader because i need to read 4 rows from the same table and i dun know any other shorter way out. Any suggestion in how i should do it?
|
|
|
|
|
Wow.
Take a step back and do some reading. If they are all in the same table, then you only need one reader, each row will contain all the values you need, assuming you select them.
Christian Graus - C++ MVP
|
|
|
|
|
DO u have any site where by i am able to read the information i like. I am quite a noob to coding. Or do u have any sample code on that?
|
|
|
|
|
You're on a site full of articles. But, if you're really that new, then you really need to take a step back, and work through a book or two.
http://msdn.microsoft.com [^] is full of info as well, but this [^]is the best way to search it, use site:msdn.microsoft.com in your search string.
Christian Graus - C++ MVP
|
|
|
|
|
What kind of objects are you using? How are the objects related?
It looks kind of like you are reading from four tables simultaneously. Why would you do that? Can't you combine them into one result when you query the database?
---
b { font-weight: normal; }
|
|
|
|
|
assuming you've a data control
data1.refresh
data1.recordsource = "select * from yourdb"
data1.recordset.movefirst
do while not data1.recordset.eof
strFirstField = data1.recordset.fields("Field1").value
strSecondField = data1.recordset.fields("Field2").value
data1.recordset.movenext
loop
|
|
|
|
|
i dun understand ur question. Ya, i need to read 4 diff rows from the same table therefore i use 4 reader. I do not know any shorter way to combine in one result. Any suggestion on tis error u can provide me with??
|
|
|
|
|
Subjugate wrote: Ya, i need to read 4 diff rows from the same table therefore i use 4 reader
You need four rows, or four columns ? If you need four rows, then you need to do a select that requests those four. If you need four columns, your select statement should request those four.
Christian Graus - C++ MVP
|
|
|
|
|
He's using four readers as he needs four columns from one table. I suspect that's the core issue.
Christian Graus - C++ MVP
|
|
|
|
|
Ya.. sori for my explanation error i need 4 columns from the same table. U mean i just need to use the SELECT sql to retrieve my 4 columns?
|
|
|
|
|
Yes, if you do a Select *, then all four columns will be read. dTable3.Rows(0)("Frequency") is reading the Frequency column, that's how you specify any column on the one reader.
Christian Graus - C++ MVP
|
|
|
|
|
oh ok... i understand wat u mean already.. thanks a lot u guys help... Learn sumthing new today.. 
|
|
|
|
|
All,
Trying to serialize a data table for file storage in a simple window application. Is this possible and if it is can anyone point me in the direction of an example or help explain how I would go about coding it. I basically want the user to generate the table and be able to save and load it at a later stage.
The xml file will contain the data table info and further information not linked to the table.
I've only started looking at XML and while I believe I have grasped the basic concept there is a lot of info out there that is misleading.
Thanks for any help you can give.
|
|
|
|
|
look into these 2 methods
datatable.ReadXml()
datatable.WriteXml()
|
|
|
|
|
I have two combo boxes that have a parent child relationship. So when comboA changes comboB uses a new DataSource and the drop down values are updated. This works correctly, but now I am databinding the selectedvalues of each combo box to an object. Sometimes the databinding works correctly, meaning comboA is bound first then comboB updates with a new list and comboB's value is bound correctly. Sometimes comboB is bound before A which causes B to be empty after A populates itself.
How do you control the order in which values are bound to their controls? I have tried changing the order of the combo boxes on the form, but no luck. Anyone have any ideas?
Thanks
Mike Lasseter
|
|
|
|
|
mr_lasseter wrote: How do you control the order in which values are bound to their controls?
By doing it in code instead of via the designer.
|
|
|
|
|
Yeah, that's what I ended up doing, but no control through the designer?
Mike Lasseter
|
|
|
|
|
I wouldn't expect so. The designer will always be a set of shortcuts for people who prefer not to have to write code. It can never be as flexible as actual programming.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
