Member Avatar

Good day, I am having trouble with my dbase. i have 2 tables first is the maintenance table while the other is transactional table. on my maintenance table i have field(id, plan, material,type,percentage) while on the transaction table (id,material,description) here is my problem. on the maintenance table let say id plan material type percentage 1 1010 sample in transit 100 2 1011 example haulage 50 3 1012 mysample production 100 based on the data above i want to select type and join it on the transactional table. let say... id material description INTRANSIT HAULAGE PRODUCTION 1 sample sample description 100 …

Member Avatar
0
14
Member Avatar

I am working with a tabbed form. On the first tab I have a datagridview with customers in it and a searching textbox. I have that working. On the second tab I am placing another datagridview with customer transactions and other data. The customer transaction table has a CustomerID Column which matches the key column in the Customer table on which the first datagridview is based. I am trying to save the key column value in a textbox so that I can use it to filter the datagridview in the second tab. I can fill in the textbox that contains …

Member Avatar
0
18
Member Avatar

Whenever I try to connect to my website over my network (from any device), my browser gives me an error saying that it could not connect to the host. I've tried a proxy, as well as downorjustme, and it works fine. I've recently performed some database work, nothing too important, but between the last time I could access my site and now, I haven't altered anything, except dropping all my tables and erasing my databases after finding out that my site was experiencing downtime, although, as I mentioned before, only on my network. My site's still experiencing that same problem, …

Member Avatar
0
9
Member Avatar

Hey, [B][U]Problem:[/U][/B] Need to find an algorithm that given 2 sequences of [B]n[/B] numbers each, say [B]S1[/B] and [B]S2[/B], and 1 number, say [B]x[/B], it would tell if x is in the sum result of S1 and S2. The hashing function, say [B]h[/B], must be picked at random from a universal set of hashing functions, say [B]H[/B]. The algorithm should not take more than [B]O(n)[/B] time. [B][U]My attempt:[/U][/B] Assume H is a universal hashing family, from which h(z) is picked at random. Use h on every element, say [B]s1[/B] in [B]S1[/B] and [B]s2[/B] in [B]S2[/B] to compute [B]h(s1 + s2)[/B] …

Member Avatar
0
19
Member Avatar

Lookup table is usually the fastest method to find function value, if number of values is small. Here we demonstrate the principle by using task of showing the value of byte as binary string or transforming binary string to byte binary value.

0
2
Member Avatar

Hi, I am developing some code to run on hardware and I am using the sin() and cos() functions inside the standard math.h many times, which slows the program down dramatically. I was wondering if there is a way to "approximate" the sine and cosine of a value (angle is between 0 and 2pi). Apparently there is a way to do it using look up tables but I don't really know how to create one? I would like to do it using just basic arithmetic operators, no math.h functions. Is there a simple way to compute the sine and cosine …

Member Avatar
0
7
Member Avatar

Hi all, I'm having some problem with my codes. I have a output that is generated into a txt file. Now, I need to read the txt file and convert the output into something else. This is the output that is store in a txt file: VAL LEU SER PRO ALA ASP LYS THR ASN They are all amino acid 3-letter abbreviation. I need to convert them into 1-letter abbreviation. For example, Val should be 'V'. Leu should be 'L'. Ser should be 'S'. Pro should be 'P'. Ala should be 'A'. Asp should be 'D'. Lys should be 'K'. …

Member Avatar
0
4
Member Avatar
Reusable Code Snippet One word anagrams by lookup

As I told before here is second implementation of one word anagrams, which prepares lookup table for all available words, if it is not generated and afterwards uses it for fast lookup. The implementation of lookup table generation is quite unoptimized, but it is only done once per vocabulary. If you want to change dictionary, add dictionary selection routine instead of fixed one here or just rename/delete old dictionary and anawords and analist files. Then make copy of your dictionary in same dictionary as this program with name list.txt. First run: [CODE] Dict prepared in 0.726 s Dict saved for …

Member Avatar
0
4
Member Avatar

Whilst having 20+yrs in IT I'm brand new to Python programming... I'm trying to reference an object in a different class as a lookup... I have a class which describes items and their prices I have a class which describes a currency code and a conversion rate I'm trying to auto-calculate the local price based on currency conversion lookup. I can't seem to find the best way of linking the two. Any ideas please? [CODE] class Currency(object): def __init__(self, currency, conversion_rate): self.currency = currency self.conversion_rate = conversion_rate def getconversionrate(self, currency): return self.conversion_rate class Stock_Detail(object): def __init__(self, item, cost, local_cost, currency): …

Member Avatar
0
19
Member Avatar

This code takes in a scrambled input word and gives out the unscrambled list of words. Eg... Input = time Output = mite, item, emit etc. I had posted an unscrambler in java sometime ago. This one is the improvement over the previous one. In the sense, the java unscrambler took an input word, and produced all permutations of the input word, did a binary search of each permutation on the list of available words. The problem was that if the input word is sufficiently large, it would produce an OutOfMemory error, because the permutations would be large. The improvement …

Member Avatar
0
12
Member Avatar

hello and thank you in advance to anyone who can help me with this problem. I've scoured the internetz for a while trying to find a solution to what must be a common question, but I can't find anything that relates to what I am trying to do. I have an EDIT form so users can edit their profile. One of the fields is a select menu populated with the contents of a second table. Example. A users wants to change their color preference. USERS user_id \ name \ color_id -------------------------- 1 | Bob | 1 2 | Steve | …

Member Avatar
0
8
Member Avatar

I'm stumped with a somewhat complicated 'lookup table' situation. I've tried many different methods to output the data I need (and in the order I need it) but I think I'm just going around in circles. Basically I'm trying to output a <select> dropdown form element, with serveral different <options> which refer to the available sizes and colours of a garment. My table layouts are as follows: [COLOR="Red"]colours.table[/COLOR] [COLOR="Green"]id, colour_name[/COLOR] 1, Black 2, White 3, Black & White tie-dye 4, Grey 5, Beige [I](as you can see, these are not stored in alphabetical order as new colours can always be …

Member Avatar
0
5
Member Avatar

I'm hoping to get some help with sorting database results based on the results themselves. I have two tables in this example, one being 'product_category_lookup.table' and the other 'products.table'. The 'product_category_lookup.table' holds data which tells the website which products are associated with which categories. The reason I have a lookup table here rather than just having a 'category' column in 'products.table' is that one product could belong to 7 different categories (think Mens, T-Shirts, Cotton etc.). My current code is working fine in terms of retrieving the correct data when I view a category, the issue is however that I …

Member Avatar
0
6
Member Avatar

Hi, I am new to Access 2007. I have two columns in my table, Make and Model. The Make column is a lookup from a Makes table which has different makes of computer (Dell, Toshiba, etc...) in it. I also have a Model column adjacent to it which is set up in a similar way, it looks up to a table named Models and has different model names (Satellite, Dimension, etc...). Is there any way so that when I select a Make, that when I go to choose the Model, only the models from the particular Make are displayed? For …

Member Avatar
0
8

The End.