o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Query Traverse -

...Im sure there is a way to do this. I just happen to be unaware of it. What I would like to do is query the database and in doing so check for a record and send me either true or false on its presence. Does anyone have any idea what the SQL would look like?

Thanks

Dave

 

Query Traverse -
...Im sure there is a way to do this. I just happen to be unaware of it. What I would like to do is query the database and in doing so check for a record and send me either true or false on its presence. Does anyone have any idea what the SQL would look like? Thanks Dave

Returning Recursive values -
I know this might be a simple recursion question to some of you but I'm just a beginner to VB and to the whole programming world so please bear with me if my question seems a little bit dumb.... Lets say you have a search tree structure and you want to traverse the the tree to get a v

[2005] Traverse a TreeView -
Hi All, I would like to ask how to traverse a TreeView. Private Sub showTree (TreeView t) ‘display a treeView to the screen which structure is an unknown End Sub Mike

Need help in sql statement -
Hello everybody, I need help in writing sql statement to traverse data. For example if I have a table that contains family information where there is a PersonID and ParentID where parent is also a person, how can I traverse person, say if I need to find all the parents of a person

Excel Column traversing -
I have 216 colums, and I need to get the sum of each column. Is there any way for me to traverse through each column? Here's the info I have, and what I'm trying to do: 1. my rows are a variable (ex:146) 2. I have 216 colums 3. I need to get the sum of 146 rows in each column

Traverse Listbox Items -
Hi all, I have a databound listbox and I want to traverse all the items in the listbox with a loop. For example, I want to print all the items of the listbox in Message Boxs one by one. Thanks.

How to traverse class properties for Nunit tests -
Hi I am working on a project in which I need to NUnit testing. To do that I need to write tests for each class. I am trying to automate that process. 1. How to know names of public properties of class in .Net dynamically? 2. I am also looking for property types to set some defaul

Traverse 2D array [resolved] -
Hi I have a 2D array : imageTileArray and I would like to traverse it i.e. visit every entry in the array sequentially. I've had a go at doing it myself as follows but i get address violations: for(i=0; i < sizeof(imageTileArray[i]); i++) { for(j=0; j < sizeof(

Quick Question Treeview -
Hi! Can anyone give me a function like this: vtAdd(strNode,strChild){ } This function should add the strChild as a child node of the strNode node. Im thinking I should traverse through the tree to check for strNode and if its there traverse through the children and place it at

Traverse shapes on drawing canvas -
Hi I have a drawing canvas in word which is a collection of shapes. For instance if I click on one of the shapes in the drawing canvas I can format it. How do you traverse all the shapes in the drawing canvas object?

How traverse the NAT with winsock -
I resolved, I thank you all

Transform Query with sub query -
Is there any way in acccess to perform a Tranform query , and include in the where clause a Sub query? I always get a error the the filed from the main query is not a valid field in the sub query.

how to traverse the each node in vbscript -
hi friends, this is my xml <screen1> <title> <text>Title1</text> </title> <mainheading> <text>InfoWave</text> </mainheading> <subheading> <text>Home</text> </subheading> </screen1&

Programming Microsoft Query -
Hi, Does anyone know if it's possible to program MS Query, and if so, how do one go ahead? I would like to call up the query wizard from within my application, and then create a report in excel based on the query the user created with ms query. Of course, I can write my own q

Traverse Folders/Subfolders -
I have a problem with traversing through all folders/subfolders in a given media (etc cd-rom, hdd). I want to display the names of all files in all folders and subfolders in a listbox. Even though i am using application.doevents(), i seem to be able to traverse the folders once. I have

Query a Query -
In the query builder in visual studio 2008 (visual basic) can you use an already created query in a new query,i.e. in a new query called query2, use table1 and query1. If not in the query builder, which would be very helpful, is there another way in StoredProcedures or code? T

ftw problem -
any ideas on how to get ftw to traverse the file tree so that it access the files before the subdirs??? It's prooving to be quite awqward for my program to function properly without this...

Traversing & Assembling File structures. -
I have a VB6 question. I am trying to traverse a directory / sub-directory structure while at the same time assembling the file names within the structure. Here is an example of what I am looking for. DIRECTORY SUB DIRECTORY FILE1 FILE2 SUB DIRECTOR

Optimize query -
HI friends I have a long query that query contains 5 tables and joins are done very correct but that query s taking lot of time where as data in tables are not large.Now I wat to optmize that query how should I do that Is there any tool available for optimizing the query. I am w

Query Problem -
Hi Sir this time iam having problem with Query first when i run the query its ok but secound time when i run query it gives error that the query is already open. so some knowes how come over this peoblem please let me know thanks the Query for reporting and i give paramete

Access query and VB .NET problem -
Hi! I have trouble accessing data from a query. I am using VS.NET 2003 against ACcess 2000. The acces query returns two fields and many rows. The query works fine in access. How should i set it up in vb .net to retrieve all the data from the query ? I tried using a datareader but

Query on the fly -
Hi i want to create a query on the fly. Meaning i have a query that contains, name,class,group,attend,date.... What i want to do is select a certain date from this query and put them into another query(temperary if possible). can this be done. I'm using MS Access,VB6... Thanking yo

Menu list -
I have seen a chunk of code somewhere that allows the user to traverse an applications menus and create a list (.txt) of all the menu's and the items under them. Could anyone help on where I could find this again or how to do this. Thanks

Running a Query -
I'm using VB6 and Access 97. I want to run an Append query using VB. I've got a Query called Transfer which has a parameter called Refno. I want to be able to send the reference from VB into this query. Which will hopefully run this query and update another table. Could anyone pleas

Referencing an Access query in VBA -
I'm trying to update a regular "Select" query using code in VBA, but I'm not too sure how to do this. I want to run the query in VBA using the docmd.runsql statement, and then I want to reference the results of that query using another query(UPDATE query) to update values in

Handling Query Results with Common Function -
I have a several query routines. These query routines narrow the resulting recordset to just one record. I also have a Public structure that is contained in a Sub/Function. I would like to assign the final query result (the one record) to the structure without having to replic

Mailing the Query -
hi i m trying to do .. like if some one writes a query.. then after submiting the query the query will be mailed to my gmail account.. thnks in advance

Query question------Solved -
I have created a query, which holds a lot of data, from different people. Meaning i have a time and attendance program with VB6 and access database. In the query i have all the different student names, I want to be able to just select a specific name from the query and show all realate

Program hangs while executing query -
I have a program that runs reports based on a rather lengthy query. While the query is running the program hangs and if minimized will not allow the user to restore the window until the query is finished. Is there anyway around this? I have used the DoEvents while manipulating the data

Executing MS Access query from VB.NET. -
I have created a query to retrieve certain results and a report that is connected to this query. This query asks for date parameter to retrieve results. It looks somewhat like this: Select TicketNo, Name, TotalFee from [MainEntry] Where DateIssue=?; I created this query in MS Acc

Tree traversal without recursion -
Is it possible to traverse (ie visiting every node) a tree without using recursion? If yes, could you please outline the algorithm? [sorry I inadvertently posted it twice]

Autocad, Viso and VBA -
Does anyone know how to traverse through a list of layer objects stored in an Autocad *.dwg file using VBA in Microsoft Viso? Thanks Markus

[2005] Is treenode index is unique for whole Treeview -
Hi guys, I want only answer only in yes or no. Because, I want to traverse whole treeview using it's node's index.. Thanks

[2005] Creating DGV Headers via SQL Query -
I have a DataGridView in which I need to create the HeaderCells via a SQL Query. Essentially what the query does is get a predetermined number of columns based on a userID. Each column returned in the query needs to become a Header on my DGV. This query is run as a Stored Procedure. Do

Quickie on files -
heya gang. Quick question. In visual basic, you can traverse through files by using FileSystemObject. How do you do this in visual C++? any help on this would be really great Thx Elon

Webbrowser control (Resolved) -
I want to traverse alll the Textboxes in a webpage displayed in a WebBrowser Control...Can anyone tell me how to do this?

Access Help fast!! -
How do you insert the result of a query into a table SELECT [Query Form].[emp #], [Query Form].observer, [Name Entry].[Obsr Emp #], [Query Form].Observee FROM [Query Form] LEFT JOIN [Name Entry] ON [Query Form].[emp #] = [Name Entry].[Emp #];

execute a .sql query from within VB.Net easily -
Hi all, Is it possible to run a .sql query (from Query Analyzer for example) in VB.Net without too much hassle?? I know people will say, make it a Stored Procedure...but I'm wanting to see about using the .sql query, which is a basic text file I assume? Any suggestions, tips

Display a query result in a textbox -
I know in a combo box you can use the record source to call a table/query and have data displayed in the combo box. What about in a textbox? I have a form which is already referencing a query. Now, I created a query which gets certain equipment records from an account and sums t

Record Count of Query Results - Access98 -
I am running a quick little VB code which simply sends a query out as an Excel document to a list of contacts. However, if the query results contain no records, the attachment is still sent. How can I check the number of records in query to determine whether or not the e-mail shoul