daniel aristidou
Last Activity: Jul 27 '12, 04:04 PM
Joined: Aug 25 '07
Location: Cyprus
-
Drupal Solution
Try Drupal they have an excellent e-commerce distribution. UberCart. It is a website CMS based on PHP http://drupal.org and
http://drupal.org/project/uberdrupal
You will need to probably install an Apache stack server I personally would recommend acquia desktop found at https://www.acquia.com/downloads...Leave a comment:
-
use "select case" and alot of if statements.
making sure you comment all of your code at the top of each select statement, this should make the task easier.Leave a comment:
-
what you want to look at is the data binding properties of the combo box, when you are in design view. from here you can select which columns are shown, and which columns value will be used when using the combo box.Leave a comment:
-
Thanks CK - That has helped alot :)Leave a comment:
-
why don't u simply use a filedialog for the user to select the database on first use of the program (easily done in new versions of vb. im not sure about older versions) , you can then store this in a text file which is located in the applications folder, or in the registry. Then on start-up make you program retrieve the path of the database to use in your application.
Also it sounds like you are looking for a solution that does not mean...Leave a comment:
-
Multiple Functions
hi guys what i am trying to do with my query is to for all of the workers in the database calculate their sales and return only their personal best. (within a certain time period)
so there are two basic steps calculate the sale total-but then only return the Max Value calculated for each worker.Code:SUM((ProductSale.Amount * ProductSale.CRPrice) * ((100 - ProductSale.Discount) / 100))
So i assume i need a Max Function on... -
Thanks CK Your help is really appreciated, The tips you gave me above helped me greatly.
But following up this question i have another problem i need to merge this table with a similar one. Here are the two codes...Code:SELECT Worker.WName, Worker.WMob, Worker.WID, Worker.WTel, SUM((ProductSale.Amount * ProductSale.CRPrice) * ((100 - ProductSale.Discount) / 100)) AS SOLD FROM WorkerLeave a comment:
-
well i guess you must be using a wrong if statement, if it works in a for loop and not in a while loop.
Try using comments in your code, this will make an error which is like this alot easier and enables you to figure out logic errors easier. Write down the logic of the loop in plain language.
Another techique to use when checking ur code in loops is to use a variable table. Where you make a table and change the variables in order downwards...Leave a comment:
-
Thanks :)
The message you have entered is too short. Please lengthen your message to at least 20 characters.Leave a comment:
-
um i just got a question why are you looking up in another query, is it not possible to create a single query rather than multiple queries, Which you are at the moment.
And secondly im no expert in sql but from what i know it seems u have 2 conditions. you are asking it to tell you if the [Sum of knowledge] is like TEl2 .... When Tel2 is equal to 1- If that is what you intend to achieve why not simply use:
...Code:Select * From ReportQ
Leave a comment:
-
Complicated Query by date
Hi guys,
i hope this question belongs here as i intend to work a solution in sql server which is my back end system rather than my front end system which is VB.
Im trying to create a query that performs a number of calculations on data and returns a table of workers and the amount they sold (in cash) between a certain period of time.
Well here are my relevant tables:
Worker 'Worker table... -
Posting Question
hi guys.
i just got a posting question since its been a while since ive been on.
im using visual basic to produce a program with sql server datafile as backend database.
im having problems developing a complex query, where should i post the question?
thanx for your help :P
Daniel Aristidou -
Crystal Reports no data
Hi guys,
I was told this question belongs in this forum so lets hope it does,
Im trying to create a crystal report,
i start the wizard and select the connection and the fields i want etc, when im done when i preview the report however no data is shown.
ive tryed reconnecting it to the database during runtime.
Also when i select the database fields during report design window... -
Thanks Man, it certainly has benn more than 100days :P
I solved the problem :P
Created a dataset on the form, loaded the table adapters
Changed datasource to dataset on report initialization
just a question but what questions regarding visaul basic in visual studio can i ask in the vb forum nowadays? and whats the difference between the new .Net forum and vb.net
...Leave a comment:
-
Crystal Reports Database Connection
Hi guys, its been a while.
Ive finally got crystal reports for visual basic studio 2008, and i keep getting problem after problem using it.
At first i coneected to an access databse(unsecur e) to produce reports. This worked fine while viewing the report in the design viewer however when i ran the aplication it asked for login details, and i could not get past that.
Now i have moved on to sql databases... -
Leave a comment:
-
Hi i posted a article that was never developed that contained how to create a demo like this. It is simple to do but is not hack proof if u know what i mean. i uses settings to save a number that tells u how long the program has been in use.
ill find the link and post it belowLeave a comment:
-
To learn how to code in WPF try downloading the silverlight sdk manual i found it very informative on how to code.Leave a comment:
-
ok thanks guys
so let me get this straight :P before i go ahead
If i go to my hard drive, and delete all folders except for the program and windows folders. it will remove all data apart from os and programs?
Will i then have to recreate the other folders?
Thanks guys Daniel...Leave a comment:
No activity results to display
Leave a comment: