Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Valeriya

    Schedule query execution vie SQL*PLUS

    Hi guys, Thank you very much for the valuable information! I was able to schedule and output to a CSV file.
  2. Valeriya

    Schedule query execution vie SQL*PLUS

    Hi all! I have a basic question. I have a query that takes two dates as parameters that needs to be scheduled vie SQL*Plus. What is the command that I would need to use? What are the steps that I would need to take? Basically, I need the output to be spooled to an Excel file (or csv, if Excel...
  3. Valeriya

    VB 6.0 interpretaion of Oracle sql "with clause"

    Thanks much to both of you!!! The problem, just like both of you stated, is not with VB SQL. It is the ODBC driver that causes a problem.
  4. Valeriya

    VB 6.0 interpretaion of Oracle sql "with clause"

    Hello everyone! I have a VB 6.0 / Oracle 9i questions. Basically, I have this query that uses "with clause" as a temp in-line view. The reasons I have to do that is because I can't use PL/SQL (our group is not allowed to create objects in the database) so this temp view is used many times in the...
  5. Valeriya

    Can Grow in Report Still Not Showing All Data

    Hello, Sorry for the confusion Guys. Let me clarify the problem again: 1.The Report with truncated data in the Text Box is based on the Query. 2. That Query is based on the Table 3. Table in sequence gets populated from the Form. Everything is looks good until it gets to the Query. What I...
  6. Valeriya

    Can Grow in Report Still Not Showing All Data

    Hey Guys, Just figured out that I was wrong in my previous post, saying that data are not truncated in the table. It is truncated in the Table, but all data fully displayed on the Form. (???) The following is the "problem" Text Box Properties: Text Box Scope: FORMAT EMTRY...
  7. Valeriya

    Can Grow in Report Still Not Showing All Data

    THANKS a LOT for all of your advises! But it seems like dhookom was right, the problem with that memo field is that the data is being truncated in the query that report is based on. Now I'm stuck again and hoping for some help. The Report that currently has this problem is based on the...
  8. Valeriya

    Can Grow in Report Still Not Showing All Data

    Hello, Thanks lameid for you advise, but unfortunately that hasn't work either. I created blank report that displays only the textbox with the can grows set for only that problem record. And it's still showing truncated on the same page. Please advise, Thanks in advance! Valeria
  9. Valeriya

    Can Grow in Report Still Not Showing All Data

    Thank you Guys for your responses! But unfortunately,tried all of your fixes,none of them worked. I've also tried to adapt VBA "TextHeightWidth" solution, offered by Stephen Lebans and it hasn't worked either. Please advise, what else could possibly cause that kind of problem? Thank you in...
  10. Valeriya

    Can Grow in Report Still Not Showing All Data

    Hello, I have Access 2000, and I have a report with a text box which has the "Can Grow" & "can Shrink" set to yes. Regardless, it still doesn't show all the data of the text box. Tips? Thanks, Valeria
  11. Valeriya

    can I enable GridView paging if Grid is bound to data source programma

    Thank you very much for your quick answer! I don’t understand why it works, but it does. I created the event, with no code inside and it took care of the problem. What was causing the problem and why did adding event resolve it? Thanks you again for your kind help!!! Valeriya
  12. Valeriya

    can I enable GridView paging if Grid is bound to data source programma

    Sure, I get this is the exception: The GridView 'GridView1' fired event PageIndexChanging which wasn't handled. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it...
  13. Valeriya

    can I enable GridView paging if Grid is bound to data source programma

    Hi. I have a problem with my GridView (asp.net 2.0)...Here is what I'm doing. My GridView is bound (HTML tags) to a DataSet. This GridView displays about 8,000 records (paging is enabled). I have added a TextBox which works as a filter on the GridView. User enters search value in this text...
  14. Valeriya

    FormView, can it be double bound?

    It worked, thanks much!
  15. Valeriya

    FormView, can it be double bound?

    I'm using an ObjectDataSource...Would that be handled differently? Thanks...Valeriya
  16. Valeriya

    FormView, can it be double bound?

    Hello guys! I'm using a FormView to Update(Edit) records in my database. Here is my problem. My FormView is bound to the stored procedure that based on the 3 parameters updates a record in the data base. First parameter is a filter to go to the specific record and the other two will take on the...
  17. Valeriya

    Need to get rid off double quotes when Exporting String to .txt file

    Thanks a million! It's works perfect now! Do you happen to know how(or is it possible)to attach a date stamp along with Network User ID to the file name? Sub TextIOWrite(sText As String) Dim sFile As String Dim iFileNum As Integer sFile = "Newtwork Drive:\Network_Folder\m/d/yyyy h:mm...
  18. Valeriya

    Need to get rid off double quotes when Exporting String to .txt file

    Hi everyone! I wanted to see if there is a way to get rid off double quotes when programmatically writing string to a .txt file. In order for me to further use data from the text file it needs to be without double quotes. I tried to use Left() and Right() on the string, however, that yields no...
  19. Valeriya

    Problem understanding properties

    Blind me! :) I found my mistake too, just a bit ago. Thanks to both of you for telling me about reusing same object!!! Books don't talk about these issues much. Again thank you very much for the valuable tips! Valeriya

Part and Inventory Search

Back
Top