2,951 Posted Topics
 | |
| | You are guilty of two counts. 1. Digging a dead thread / Hijacking others thread. 2. Not showing any effort. Suggestion :- 1. Start a new thread for your own question. 2. shows some effort and post the code that you are working on.  |
| | You want to select the items in the same row, not the same item ? |
| | |
| | Re: ProgramWorld Welcome to Daniweb. Please post your question in the proper section only. Also don't forget to mention what you have tried so far and where exactly you are struck.  |
| | |
| | |
| | What is the table structure and what is the code that you are working on ? |
| | That version is not supported any more so is not available for download. Download the latest version from [URL="http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html"]here[/URL]. it is free to download for unlimited evaluation. |
 | Execution time is independent of lines of code. It may happen that a procedure has 1000 lines of code because of a long running IF ELSE but the line 10 to 1000 never gets executed. It depends on what the code is actually doing. |
| | You need to pass only the desired record set to the report not the entire table. |
| | |
| | Of course you can ask for that my dear. That will be delivered to with complementary gift wrapping with a scented red rose. The only thing you need to conform is how are you going to pay for my service. |
| | Re: Reverse function I really do not understand what do you mean by -- [B]I ran ltrim(), rtrim() and lower() function on data successfully. But fail to retrieve this data.[/B] |
| | |
| | |
| | I don't understand why you need to use any division operator and why you need any relational algebra. Kindly post the query that you are working on. |
| | Welcome to Daniweb. This section is for general introduction of new members only. Kindly post your question in the proper section of the forum.  |
 | try this sample function for the job. [code=vb] Code: Public Function NumToWord(numstr As Variant) As String Dim newstr As String numstr = CDec(numstr) If numstr = 0 Then NumToWord = "Zero" Exit Function End If If numstr > 10 ^ 24 Then NumToWord = "Number too big" Exit Function End … |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | Welcome to Daniweb. This section is for general introduction of new members only. Kindly post your question in the sub section of [URL="http://www.daniweb.com/forums/forum16.html"]this section[/URL] depending on your database. |
| | When you say, i consider you want to run the query dynamically on different field names. If that is the case then, you need to maintain a flag, along with the input parameter and based on the value of the flag frame the query dynamically and execute. [code] if p_flag=1 … |
| | 1. find out he position of last "\" from right side. 2. add 1 to that value (+ 1) 3. find out the string from this position till the end of the string. |
| | |
 | Why you need to re-invent the wheel ! All windows machines which are part of a domain works exactly this way. User details are maintained in active directory. |
| | Green hair and purple eyes, you are so colorful. BTW, do you survive on [URL="http://en.wikipedia.org/wiki/Photosynthesis"]Photosynthesis[/URL] ? :icon_mrgreen: Welcome to Daniweb. |
| | Lets eat, sleep and live cricket. I am with my home team, they are the hot favorites. |
| | What do yo expect a single line solution ? The codes provided [URL="http://www.daniweb.com/forums/thread186332.html"]in the links[/URL] is straight forward. It is lengthy because of long running IF and CASE statements. |
| | Which domain you are comfortable with ?  |
| | |
| | |
| | |
| | No duplicate thread please. |
| | ListboxName.AddItem string -----this is a method and set the [B]Sorted[/B] property to [B]True[/B] Use the above hint and post back here what code you comeup with. |
| | |
| | Why not simply make the orderItem refer to both ORDER and ITEM table for corresponding record via PK / FK.  |
| | |
| | Suggestion:-- 1. Instead of using Case cmbSearch Case "By: Customer Name": take the value from a combobox instead (use the index in CASE not the text). 2. Don't use like operator on a Date field, you will get unexpected result. Q. What is that DataGrid in your code, is that … |
 | I am sorry, i really do not understand the question. |
| | |
 | |
 | |
| | |
| |
The End.